linking tables to other tables

[detlion1643]

I have created a database with 50+ linked excel sheets. I need to take the 50+ sheets and combine them into one table, based upon columnA (primary key in all 50+ sheets). If the big table contains the primary key already (or value in column A), then the values in column 3,4,5,6,7 for that row in the little table, need to be added to the existing values in columns 3,4,5,6,7 in the big table.

Basically:
table1
cola , colb , colc , cold , cole , colf , colg, colh
aaa , aaa , 5555, 5555, 5555, 5555, 5555, 5555
bbb , bbb , 4444, 4444, 3333, 4444, 4444, 4444

table2
cola , colb , colc , cold , cole , colf , colg, colh
aaa , aaa , 3333, 3333, 4444, 3333, 3333


ccc , aaa , 2222, 2222, 2222, 2222, 1111, 2222

table3(table i need)
cola , colb , colc , cold , cole , colf , colg, colh
aaa , aaa , 8888, 8888, 9999, 8888, 8888, 8888
bbb , bbb , 4444, 4444, 3333, 4444, 4444, 4444
ccc , aaa , 2222, 2222, 2222, 2222, 1111, 2222

If table3 could be somehow linked to the others to do this, even better, that way when the excel sheets update, table3 would already be updated.

Hope this makes sense.

[NTC]

if the layout of these sheets is truly identical then simply import them all into the same table....import is a feature in File - 'Get External Data'

but note - there is probably a reason that data is on sheet 5 vs sheet 22 - maybe its a date, maybe its a town, maybe its a department - whatever the logic is for all these different sheets - - if you want to maintain their unique sheet identity then before you do the import be sure to add a column to each sheet and mass enter the appropriate ID Value into every record in the sheet (which is easy to do with excel).........because once everything is imported there isn't any way to then know which sheet the data came from, should that be important to know .....