hi
make the cell reference in your sheet1 A1 formula absolute.
how?
=Sheet2!$E$1

no matter where you paste it, it will always refer to Sheet2!$E$1

regards
FSt1

"David Frank" wrote:

Worksheet1 has cell A1 equal to contents of cell E1 on worksheet2. I want to
copy that down through A50 so that A2 equals contents of E1 on worksheet3, A3
equals E1 on worksheet4 etc. I have two problems, 1) I dont know a formula
for incrementing worksheet name by one/next worksheet name. 2) E1 reference
increments to E2, E3 etc when I copy it down through A50. Any idea on a
formula for this?
--
David Frank, Team Lightning