Hi.
I have an excel workbook with numerous sheets. On sheet 1 i wish to link
the data from the named ranges of the different worksheets.

E.g. Worksheet 2 has data in a named range for one topic, worksheet 3 has
data in a named for another etc, and worksheet 1 is the overview of the other
worksheets.

I want to link them so that if i insert a cell, row, the overview sheet
updates automatically.

Can anybody assist at all?

--
Kellie Anne