You could take the sheet that's your "master" and reference cell or cells
from another worksheet's cells. Is that what you're talking about? If
so, something like this:

Master A1 would be =SUM('Worksheet Name'!B46) where B46 is the data you
want to reference.

HTH