Combine Multiple Worksheets into one master worksheet

[HelloWorldLOL]

Good Afternoon,

A friend of mine and myself have been working on an excel spreadsheet that takes entries from 24 different spreadsheets that contain the same columns and populate them all on one master sheet. We only want to use column U:AK and the header is the two top rows. The worksheet names are D1C-D7C,D1CM-D17CM. We need to just pull the data so the top two rows which are the headers have to be ignored. We have been trying a ton of different codes but cannot get in the area of what we need. We have been seeing alot of VB errors so I think that our method of putting the code in is wrong. Please help in regards as I appreciate your time and energy.

 

[GreasySpot]

Is this a one time deal or will the master workbook need to be updated from time to time? The reason I ask is some excel functions don't work if you are reading a workbook that is closed. I'm not sure if it works the same way with VBA. Are there multiple sheets to be read in each workbook or just one sheet?

 

[HelloWorldLOL]

Thank You for your swift reply! It is multiple sheets being read and updated to a master as changes and additions are made.

 

[GreasySpot]

Are there 24 different workbooks (ie files) or 24 different worksheets in one file?

 

[HelloWorldLOL]

Yes 24 different worksheets. Sorry for the late reply.