There are usually better ways of working than making linked copies of
the data - e.g. filtering a table, or creating a pivot table with
County as a page field, making the master data be in the County sheets
and using Data Consolidate to build the combined sheet....

However, if these don't suit your needs and current data arrangement,
and if the area used for each County on the combined sheet is fixed:
Select the area for County1; Edit Copy; Select the cell on the
County1 sheet where you want the linked data to start; Edit Paste
Special Paste Link
Repeat for each county.

If the area for each county is not fixed (e.g. you might add or delete
a row in the County1 area) then I would advise against using linked
data.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup