Copy Data to Master List from Multiple Sheets

HI All,

I really appreciate the help on this forum!

I am a huge noob and have modified some vba code to copy data (varying rows all the time) from multiple sheets to a master sheet. I intend to run the code on "Activate".

Unfortunately, I am getting error even before I get to the copy code, the error is on defining the array of sheets which contain the data to be copied.

Please Login or Register  to view this content.

Does anyone see whats going on here? "For each sheet" is highlighted on debug.

For clarification, I am trying to get the array sheets to copy column data to the master for the following columns:
A2->A9
B2->B9
C2->C9
I3->E9
J3->F9
K2->D9
L2->G9

Anyone can lend a hand?