Dynamic Inventory Management in Excel

Thanks for the reply. I had actually already seen your videos. They just aren't quite what I was looking for, but did give me some ideas on how to accomplish most of what I want. I don't need all the sales related stuff, just a way to keep track of items on hand from multiple sheets.

I do wonder though, you manually named some columns. If I'm using tables that is basically the same thing as you did but the headers of the tables columns are the named ranges now for each sheet?

Also, maybe you have a solution for this. At this point I feel my full vision isn't quite possible in the way I feel it should be. So as a step back is it possible to just combine all the data from all my tables into one giant list that stays dynamic. Meaning if I add to one of the other tables, the master list sheet also gets the updated entry? So far all the ways I've seen to combine tables they are static.