I really hope someone can help, I have a master worksheet with 366 columns
and five other identical worksheets (in other folders). I need row a1 in the
master worksheet to show any entries in rows a1 from the other five. There
are no calculations the only information in any cell is colour, text,
comments and pattern only.

The data in the non master worksheets will never overlap in the mastersheet
so no problems should arise there.

Is this possible???
Please help, Kev.