Beginner Macro Question - Copying and Pasting Ranges

Hi Everyone,

I would really, really appreciate it if once again, someone could help me with a macro I am trying to write!!

I have a keycode cell, BF2, a range of cells (12 rows) whose calculations change based on the keycode, BQ11:BV22, and a range of cells (1200 rows) I would like results of the calculations pasted, BG11:BL1270.

I would like the keycode to go through 100 numbers - 1, 13, 25, 37, ..... , 1189. For each number I'd like to have it grab the 12 rows of results from BQ11:BV22, and paste them in their corresponding rows in the 1200 row range BG11:BL1270.

I hope this makes sense. Sorry for the seemingly inefficient spreadsheet, but again, would greatly appreciate any help!!

Hope this helps give you an idea of what I had in mind (note, I removed almost all the other numbers and tabs to reduce the size of the file.)