I have a sheet with data for multiple machines with the data for each machine spanning 5 rows and about 30 columns. I am consolodating all of the useful data from each set to a single row in another sheet within the same workspace, but if I try to copy and paste the row, the formulas' references only move down 1 row. Is there any way that I could make the references move down 5 rows so I would not have to change each by hand?