I have twenty pages of data, that I need to bring into a single page. The
data starts on line 137 of each and every page. Also I am only needing the
first four columns of each page. So what i have done is for the first page
is created a line to each line that I need in my summary page. Ex."
Sheet1!A137 and etc for the four columns.

What I want to do now is becasue this is already set up, I would like to now
do this Ex: Sheet1!$A$137, but do not want to do for each line and each
column that I have data in. I know that by hitting the F2 key and then the
F4 key that I can place the character where it needs to go.

Is there a way to globally do this step without having to do each cell
individually?