I'm trying to link info from several sheets into one sheet.
I know I can just put the formula "=sheet! cell " into each cell I need it to link to, but I'm trying to drag the formula down a column and the sheets are not in the same format.
Any way I can establish the formula at the top, then drag it down the column
What it's doing is
Sheet1 cell 3
I need it to do
Any help is appreciated.