Let me first try to explain what I wish to do...and maybe you can provide me some help.

I have an *Large* excel file which has multiple users. Ever day/week the name of the file changes with a new revision.
This excel file has a laundry list of items in Column A. This same list is also on several tabs in the same workbook (albeit not in the same order).

I need to use a Vlookup function to create a summary for each item. In the past, I have copied and pasted as text the tabs I needed in a new workbook and then used VLOOKUP to pull the data I need...this works...but I want to streamline my process some if I can.

Short of actually adding ANOTHER tab in the workbook (file is already 4+MB), is there anyway I can use the VLOOKUP function to search another workbook?