I have produced a workbook with a main sheet which summarises other
information from spreadsheets in the same workbook. I have used VLOOKUP and
this is fine when there is only one row of data to summarize from each
spreadsheet. Can anyone help me with a suggestion to automatically bring
through to the main sheet varying number of rows where my "primary key" could
be in between one and twenty rows.

Thank you