Merging excel workbooks into one main worksheet

[vlwilburn]

I have a master spreadsheet which is pre-populated with data (Columns A -
AP). People will be sending their data to me via a spreadsheet and I need to
have all the new data added into the master file so that I have one
spreadsheet. Fields in which new data could have been added or corrected
that need to be transferred to the master file include:
Columns N & O
Columns S – Z
Columns AB
Add any new names to be populated in Columns A, B & C. This also will be
shared and used by other members in my team when I am out of the office. Is
there any way of including Control buttons.

Thanks

 

[Ron de Bruin]

Try this add -in
http://www.rondebruin.nl/merge.htm

Or the code if you want from my site