Create a volume tracking table with VBA

Hi All

I'm trying I create something in VBA but I don't know whether I could simplify this code any further. Just to explain what this code does is update a volume tracking table on each sheet in the workbook. So for Sheet Q4 it'll go through Sheets Q1-Q3 and copy the data across to Q4.

Is there any way to simplify this with a loop - I tried but keep getting stuck because the amount I copy for Q4 is different to what I'd copy for Q1 for examples

Anyway the code is here

Please Login or Register  to view this content.

Any help guys?