Macro to pull rolling data into a fixed format to allow for year round tracking

Hi -

Sounds like

lr=sheets("destination").cells(sheets("destination").rows.count,2).end(xlup).row+1
range("a1:a30").copy sheets("destination").range("b" & lr)

Regards,
Event