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

[Gerri Johnson]

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

 

[sergioMabres]

Hi Gerri,
Yes there is, but you will have problems due to the volume of information and the amount of ppl involved, I had a similar problem, I've tried to make it work for more than two year in a project and finally decided to replace all sheets for a workflow web based system where every one inputs info, the workflow send the information to each one at the right time, and finally consolidates results at the end of the month to be once more evaluated, this is my experience in a subject that involves lots of info, reviews and ppl.
Cheers
Sergio