Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly