I have provided an example at http://www.HelpExcel.com/examples.
The name of the spreadsheet is moveData.xls
--
http://HelpExcel.com




"lob" wrote:

I have a file with a number of worksheets that are identical but have
different conditional formatting criteria, these we will call 'data
sheets'. I would like all the data from row 3 downwards in all the
'data sheets' to be listed in the 'summary worksheet' in this
file. I will need the 'summary worksheet' to be updated
automatically when data is entered in the 'data sheets'. How can
this be accomplished? Thank you for your help.