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