Multiple references to another sheet

Hi, so obviously if I want to have a given cell in one sheet reference another cell in a different sheet, this is easily achieved. 

But let's say I want cell A1 in one sheet to reference A1 in a different sheet, followed by B1 referencing B1 and so on... do I have to set these up one cell at a time??? If I try to grab the cell corner and drag the formula down it doesn't adjust to reference the next cell in that other sheet... hoping there is a way as I have a LOT of these I have to do... 

Thanks. 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!