In A1 of Sheet3 enter =Sheet!A1*Sheet2!A1
It is often easier to make these formulas by pointing: in A1 of Sheet3 type
=, click on Sheet1's tab and click on A1, in the formula bar type *, click
on Sheet2's tab and then on A1; complete formula with either Enter key of
the green check mark next to formula part.
Note: if sheet name have spaces, you need single quotes, as in 'January
data'!a1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andrew1029" wrote in message
...
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?