Pull data from multiple sheets macro

Hi,

I was previously helped with a macro which would return data from sheets 1-6 if the row contained data (if it didn’t it was ignored).

Currently it is set up to pull data for only three months. This is defined by cells E5:G5 on the upload sheet e.g. if period 1 is in cell E5 then it would pull the rows which contain data on sheets 1 to 6 in the period 1 column.

I now need the macro below amended so that it pulls 12 months rather than 3 – how would it be ameneded?

Please Login or Register  to view this content.