i am using this formula to return the week number in a header

=INDEX($B$145:$BA$145,0,MAX((B146:BA187<"")*COLUM N($B$145:$BA
$187))-1)

what i would like to do is
identify the column address that matches the week number ie column G
(this will change from week to week)
then i would like to select a range eg row 146 to row 190
copy this range
paste it on another sheet
next week G would change to H

any ideas thanks

kevin