SIMPLY... I want in my summary tab to have the data from A1-P30 to ALWAYS be
the data showing on my first page tab that is in position A1-P30.. Once a
week I move the data in my first page by moving rows up and down depending on
the performance of a certain golfer and what place he now is in overall. This
is driving me nuts!

I know all about

=page1$C$8 but that doesn't seem to work...