Adding Up inventory numbers from Monthly tabs

[Aussie1]

Hi everyone,

Hope I can be clear on this one. I am making some changes to my spreadsheet and I am unsure if what I want to do can be done.

Attached is the file. There are macro's on it just to warn you, but we won't be needing to worry about those.

I created a new tab at the end of the spreadsheet. It is called "Current Inventory". Each Month in the year has it's own tab as well. What I want to do is have what is currently in inventory show up on the "Current inventory" tab on Line D of that tab. I know what is currently in inventory on the "Ending Inventory" line of each monthly tab. So if we are in January then the "Current inventory" tab on Line D will read off of the "January Inventory" Tab of the "Ending Inventory" Line.

Dave

[brokenbiscuits]

The attached would work as a workaround?

[Aussie1]

OK. I will try this one for now.

Thanks!!