Convert formulas to values for specific rows

Hello,

I'm very new to using macros and hoping someone can help me with this. I have a weekly cashflow spreadsheet with several sheets that pull data the weekly data from the main report to annual summary sheets for different divisions. I have the sheet set up so that the data will populate the right week but then needs to be copied and pasted as values before the date is changed on the main page or the data will move too. What I want to do is set up a macro that will find the row for the current week on each of the 5 summary sheets, copy the row and paste it as values in the same spot.

If someone could help me with this or point me in the right direction I'd appreciate it.

Thanks,
Mike