How To Combine 3 Linked Excel Worksheets?

[cadsvc]

I have a situation where I can't get the Data Clerk to use Access.



1. So I am faced with 1 spreadsheet with 3 named sheets.

2. The sheets have the same columnn names.

3. The sheet names are important since they are the grouping that the end user wants to see grouped by. BUT they are not in a field on the page; just on the TABS.

The sheet names are: S1, S2, S3

The coulmn names are: Line, Date, Width

I have linked to the spreadsheet sheets since data is changed often.

How can I combine this odd collection of data into something I can query and report?

It would be great if the query returned:
Date, Line, Width, S1
Date, Line, Width, S2
Date, Line, Width, S3
...

So I can make a clean report.

I need help.

Thanks in advance.

[HawkGuru]

Have you built 3 seperate tables into your database, one for S1, S2 and S3? If so, you can link the applicable tab to the correct table. Then you can build a query or report to pull the data from all 3 tables and display it how you want.

[cadsvc]

I have linked to tables S1, S2, and S3. The links work.
The problem is with the query.
I get...
Date, Line1, Width1, Width2, Width3

Dont I need the output of the query in the following format:
Date, Line, Width1
Date, Line, Width2
Date, Line, Width3?