Originally Posted by Yak

Does "page" substitute for "sheet"?

Hypothetically, say you've got your variables in sheet 1. cost/kwh is sheet 1 cell A4. Sheet 2 is server X, sheet 3 server Y, etc. Say you've got forecast kW in B4 on sheet 2 and you need a dollar value in cell C4. Is that sort of how you're setting it up?

I think tbo's comments are basically correct and to calculate the rate*demand you just need

for sheet 2 cell c4 it would be =sheet1!A4*B4

Copying and pasting SHOULD do this for you. If the sheets have names like "variables, server X, server Y" then you may have to replace the sheet number with the name. Don't underestimate the power of "paste special" and then pick your options, like "paste values". That simply pastes the numeric value of the cell and reduces broken references. But that's a one shot deal. If you change the original cell later on, it won't propagate.