Copy Formula and Reference the Same Cell in the Next Sheet

I've hunted around the forums looking for something like this and I've found things similar to what I need, but nothing quite there. But here's the scoop:

I take inventory every month on about 200 items. I plug in two values for each item at the end of every month--the number in the DayStock and the number in the WeekStock, which are just names for different places I store things--into a sheet with all 200 items on it for that month. So, for example, at the end of this month I will fill in data on the April13 sheet. The following month, I go to the next sheet, and do the same thing for the same 200 items. All of these monthly inventory sheets are formatted the exact same way, so cell C8 refers to "the quantity of Black and White paper in DayStock at the end of the month in question" on each and every sheet.

What I need is to create a new sheet that gives me some usage statistics. The new sheet would pull the entered values from the 200 items, do some simple arithmetic and give me the total number we used during that month. But the complication appears to be that I don't want to individually write the formulas in the new sheet to pull the quantities for all 200 items x 12 months apiece. 2400 formulas is a LOT to type out, and it leaves a lot of room for human error.

I'm attaching the actual document I'm doing this with so you can play around and see if you can get it to work. Any help or suggestions would be GREATLY appreciated--I'm probably making this more complicated than it needs to be, so if there's an easier way to do it than I am doing it now, please god show me.

Master Inventory.xlsx

Originally Posted by FDibbins

Hi and welcome to the forum

Maybe this will get you started in the right direction?

=INDIRECT($A3&"!$C$8")+INDIRECT($A3&"!$D$8")

However, I would suggest that you split your headings so that
Black and White
8.5”x11” (white)

is split into 2 rows, that way you can use lookups to find the columns you want

Thanks for the response!

I think this ends up just being another way to do the addition, but unless I don't totally understand what INDIRECT can do (which is VERY possible), I don't think it will work here...

What needs to happen on the 'Usage Tracking' sheet is something like this:

C5 = March13!$C$8+March13!$D$8

and then without having to retype it,

C9 = April13!$C$8+April13!$D$8

and then

C13 = May13!$C$8+May13!$D$8


Entering all these formulas in for each of the 12 months and for each of the 200 items would absolutely work and get the functionality I need. But surely there is some way Excel can do this for me...