I have no idea how to do this. I am building a weekly menu/shopping list to
ease my grocery shopping problems. I have created a list of menu's that
coordinate with an ID. IE...1-Cheeseburger Macaroni, 2-Broccoli Cheese Soup,
etc. Then I have a tab marked 1 & on that sheet, list the ingredients I need
to purchase to make Cheeseburger Macaroni. The next thing I want to do is
have the spreadsheet go to each of the 10 menu items (aka tabs) I select &
pull over all of the ingredients from each of those 10 individual tabs to
make 1 shopping list alphabetically. Does that make sense? My first thought
was to use VLOOKUP to reference the appropriate tab & pull over the data from
that tab but I can't figure out if it is even possible to put a cell
reference into a VLOOKUP but have the cell reference actually referencing the
tab that it needs to look at for the ingredient list. If there is a
different method that makes more sense or would be easier, I would be open to
any suggestions.