Merge data from one worksheet to another

[Garrek]

I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to populate B5 on the master etc. Would it be easiest to use VBA to complete this? There are enough numbers that manually copying and pasting every week would be a big hassle.

My big concern right now is naming, as the weekly report always has the same name, so I don't want it to pull from the wrong report.

 

[DanteAmor]

Do you need something like this?

Sub Merge_data()
  Dim sh1 As Worksheet, sh2 As Worksheet
  Set sh1 = Sheets("Report")
  Set sh2 = Sheets("Master")
  sh2.Range("B5").Value = sh1.Range("F33").Value
  'put the next cells
  sh2.Range("D6").Value = sh1.Range("G50").Value
  'etc
End Sub