hOW TO MERGE DATA FROM SEVERAL WORKSHEETS INTO ONE

Hi

Best way to use indirect and vlookup!
Date page won't work with this JAN-14 and FEB-14!!
I change to this 114 and 214 page
Now it working 100%

Return Consolidated: Column B4:AQ4 Make sure it same words as 114 and 214 page C4:C51

See the file

Regard
micope21

Thanks for the reply.

I have attached the file with some comments of how my thinking is in this process that might help

I appreciate your assistance

Hi

I only do simple Macros.
I can't help you there!!

Formula will work on all in automatic without the Macros button.
No Need Start or end tab? This can remove. Date in 114, 214, and 314 page stay as is it.
Cell F4 in page 114,214,314 type this Jan-14, Feb-14 and Mar-14 carry on to Dec-14
You only need Tab number like you see 114 to 1214. Next year start again 115 to 1215 so on.
Cell B6 Copy and Paste is on B7 the copy cross do the same copy down once you got new page like 414 so on to 1214.

If you want Macros. Then nothing more I can help you with!!

See the file

Regard
micope21

Thanks for your help.

IS the form now populated using the consolidate option?