Hello ... I use Excel at work from time to time, but not extensively, also I
am very new to Excel 2007.

I have worksheets that need to be linked. One is what we call a total
worksheet .. it contains copies of all smaller worksheets, 20 in all. I
need to have excel update the total worksheet each time one of the smaller
worksheets is altered. These are all separate files, each of the smaller
worksheets contains up to 30 rows of data.

Can I make a macro which will create the link between the total and smaller
(detail) worksheets. I expect I have to have the total worksheet open and
then open the detail worksheets one by one.

Apologies if this is not very clear & any help that would cut down the
manual labour would be most appreciated.

Abay