Hello,

I currently manage the inventories across several product lines for several store locations. Right now I have each product line in its own workbook, with tabs for each store in each. I have variables set up on a separate tab/sheet in each workbook. My question is this: I'd like to design a more elegant solution to this. I use the same set of variables across each product line (i.e., how many days into the current month we are, etc.). Another variable is the targeted number of weeks we want to have either on ground or on the way. This fluctuates by product line and market trend. Does anyone have any suggestions on possibly combining the workbooks, or creating one sheet of variables to feed all of the product lines, and create a dashboard of sorts to quickly show my boss inventory coverage across each product line, all in one place?

This may not be too clear, so if you think you have a good idea but need me to explain something better, please let me know. Thanks so much in advance!