copy value from one sheet to another

Hi there
firstly apologies if this is the most basic question ever!

I have a workbook with several pages
page 1 - summary page
page 2 - calcs etc

I have a macro on page 2 that when run copies say 10 rows from elsewhere in the page to the 'calculation' area
my problem is how to reference this on page 1

if i reference the cell with the macro already having been run then i get a #ref error when i open the book
if i reference the cell without the macr run then when i do run the macro the referenced cell (lets say f10) changes to f20
I have tried $f$10 but this makes no odds

There are a choice of macros to achieve the same resuilt - (depending on size of additional product)
or none if no additions are required

hope i have been sufficiently detailed in my question
many thanks in advance

Hi there
apologies for the breach of protocol
i attach a form of the sheet i am working on
the only insertable is the top one (in yellow) rows 73-87
The macro - once clicked - appears from row 25
I want to eventually be able to put several values from this into row 39 (after macro run)

I was not expecting to have additions to macros ... more expecting to be informed of a 'basic' that i didnt know about
anyhoo...
thanks in advance to whomever is helpful
xxx

ok... so I have a fix (although not ideal)
i have made another macro ... with another button... on click of button this macro is executed:
Sub Rectangle3_Click()
Worksheets("R-A").Range("J35").Copy _
Destination:=Worksheets("R-A").Range("J39")
Worksheets("R-A").Range("h35").Copy _
Destination:=Worksheets("R-A").Range("i39")
End Sub
this works but I will have to copy and modify the same macro multiple times as I have multiple pages
I guess as i go I will become more proficient and learn sneaky shortcuts
for example can you , rather than specifying the sheet (R-A), just say "this sheet?"
learn learn learn...

Sub Rectangle3_Click()
Range("J35").Copy _
Destination:=Range("J39")
Range("h35").Copy _
Range("i39")
End Sub

obvs...lol