10 tables one query

I have 10 tables. They are linked to 10 spread sheets. How can I link all ten tables together or to one query? In my query I tried to link them but the only thing that was queried was batch 3. All spreadsheets have an added field called batch. Each batch has a separate mail merge document attached to it (command button). I need a way to query all 10 tables to show which batch a particular SSN is listed. Please help...... Any help is greatly needed and appreciated.

Reg

By spreadsheet, do you mean a datasheet?

Each table must have a unique index key linking it to the successsive table, in one to one, or one to many relations. If the keys are not unique (indexed), you'll get mutliple and incorrect values. Also, 10 tables sounds a bit too much, but it depends on the number of fields.

This method will give you the result but you won't know which table the data is in unless there is some field which indicates this separately.

Thanks a million. I took the easy way out and created a table with the key information.