Yes, use this notation:

In cell A1 in sheet 3:

='sheet 1'!A1 * 'sheet2'!A1

--
Regards,

Dave


"Andrew1029" wrote:

Hi,

I want to make a spreadsheet that summaries information from previous
tab/worksheets within a single excel file.

For instance can you do A1 from sheet 1 multiplied by A1 from sheet 2, with
the answer appearing in A1 of sheet three?

Are these types of calculations and connections possible in excel?