Hi everyone,
I need to create a summary page of items and order quantities based on size which pulls from a master inventory list in the same workbook.
That master inventory list needs to pull whatever has been entered in a specific cell based on item number and size. This inventory list does not have available inventory or anything like that.

I cant seem to figure out the best way to create these formulas without getting them overly complicated or convoluted.

I need to find a way to make this simple enough that I can change out the item numbers and sizes without having to re-formula the whole thing every year.

Currently there are multiple sheets set up in the same way with the item number in the left hand column, a description in the second column, followed by varying headings of sizes (XS, S, M, 9, 10, 11, etc) depending on the category with a spot for the sales rep to put in what the customer has on hand, and what they think that the customer should order.

I need to pull whatever values are entered and relate them to the item number that is size specific. (hence the master inventory list)

Then I need to pull whatever items on the master inventory list that have a value into a concise one page report that has the item number with size and order quantity.

Here is the file, I hope that it works.

replen worksheet.xlsm

I don't have the summary page yet put in as well I have no idea how to go about it yet. If I could at least get the master inventory page figured out then I would be able to probably just return non blank cells or something like that.

Any help is appreciated.
(I am aware that there are actual programs out there that do this, but for some reason I was asked to do this for my boss despite us actually having the programs that already do something like this).