Please give more detail as to how the data is set out in the sheets
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SLW612" wrote in message
...
,Hello,
I have a workbook with multiple sheets. Each sheet has 4 columns and
depending on the amount of data, multiple rows (usually between 1 and 20).
I
would like to create a summary page that would search all of the
worksheets
for data entered and combine all of these rows of data (no need to search
for
duplicates - there won't be any) on one main sheet. Is this possible? It
seems like an array formula may do the trick but I'm not too deft at
writing
my own arrays.

Thank you in advance!