Good Evening,

I have created numerous worksheet that does various calculations.
I would like to be able to copy the cell form one sheet to another.
I used the lookup function with the $ sign.
My question is how do i copy that formula, and paste special or something to
all the other cells.

Example:
empl_1 is the sheet name
Column A
12
23
35
65
Total_1 is the final sheet name
i would like to copy the exact data from those columns to new column in this
sheet
I used =LOOKUP(Empl1!$B$9,Empl1!$B$9)
How do i copy this numerous times? Any help would be appreciated.
Hopefully this is not too confusing

best regards
BK