,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!