I would like to create a master sheet that shows information from a number of
sheets within a file. A majority of the cells will have a locked position but
other information ( I want to show where a name is repeated more than once in
a column) will vary in size with each update. I want to display the
information with the sheet name in column A and a number of headers such as
name, date etc along the rows.
Any one with any ideas?

Cheers