Hi

I would "bite the bullet" and do a once only copy and paste the data from
all 55 sheets onto one sheet, each set of data one block below each other to
create around 8000 rows.

I would do this in a brand new workbook, copying each sheet one at a time to
Sheet 1 of the new workbook. Once finished, you can forget about the old
workbook and do everything you want with the new one.

I would have an extra column, entitled whatever the name is for the source
sheet, and having copied the block of data from any given sheet, I would
then copy down that sheet name alongside its data.

Mark your header row and DataFilterAutofilter.
The dropdown on the "sheet name" would show just the data from that sheet.

You can then use Vlookup very easily on this one set of data.
Regards

Roger Govier


spuds wrote:
Hi
I have a very large price list in a spreadsheet, what i like to do is export
certain information from those spreadsheet into another spreadsheet ie:
Name Description price ?
what i tried to use was a lookup function but it went really bad it needs to
get info from there is 55 worksheets with each worksheet has a different
name and each sheet it has 8 colums and 150 rows but i only want a small
part of this, l hope i have asked it clearly enough for someone to help me.
Thankyou in Advance

rob