Combine Tabs on different work books to One Tab in another workbook

[GerriJohnson]

I really need help with this. So here is my problem.
I have 50 Case Mangers in different parts of the state
--- they have 50 Participants
Each participant has a separate file.
That means approximately 250 separate files are sent to me monthly.

Each file has approximately 10 tabs
Tab 1 Tab 2 Tab 3 etc.
I have named one of the tabs MIS it has 176 Data Elements that need to be answered.
That means I am collecting approximately 900 Data Elements.
By Data Elements I mean 900 cells of information collected in separate cells.
The Data Elements are in (Column A Row 1) and end in (Column FV Row 1).
I need to collect all this Data in to one spreadsheet and submit it once a month.
Each Participant file has a tab labeled MIS
So, I need to grab that tab from all Participant files and combine them into one spreadsheet.
Is there a way to do this? I have searched and found
Get and transform data
Consolidate
Queries
Please Help
Thanks Gerri Johnson

[noboffinme]

Hi Gerri,
Are the files that you want to put together the same?
I mean are the field names the same & in the same order?
You could do this either with a Macro and keep this in Excel (but this is an advanced solution only) or maybe use MS Access and get everyone to enter their details into a table to get all the data together.