Extract Data from Many Worksheets into One

[shelby55]

Hello

I'm using Excel 2003.

I am in receipt of an Excel file where each worksheet is one patient's data (50 worksheets). The data per worksheet isn't across one row i.e. CMG = C6, Sex = C15 etc. but it is in the same location per worksheet so all worksheets have CMG at the location of C6.

What I want to do is have a single worksheet for all the data with each chart having all their data elements in a row.

Is this possible? Thanks.

 

[SkipVought]

forum707.

What CELLS map to what columns?

Is each sheet identically structured?

What is master sheet named?

Please answer these when you post in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

I know this doesn't help you, but this is what happens when someone doesn't know the difference between Excel and Access, and tries to use a spreadsheet as a form. Good luck, it shouldn't be too bad in vba so long as (as Skip pointed out) every worksheet has exactly the same layout.

 

[shelby55]

Hi

Exactly, Lionel! This was a static data set but I've advised that if they wish to collect this type of information in future it is far better to do so via Access and stated all the reasons why....