Applying "HLOOKUP" or "VLOOKUP" to a macro

[ExcelFinWizzard]

I realized after posting this that hlookup/vlookup may not be the correct solution. Please read below.


Background:

I have a workbook. In the workbook I have a sheet. In the sheet I have a archive of data (starting at A200). The archive of data I have it listed out by year, then month. So, 2012 in A201, then from A202 to BC 202, I have January to February (with 4 cells proceeding each month's title). Below the month titles are apx. 197 blank rows where data should be going; then start a new year (i.e. 2012, 2014... to 2022).

At the top of the sheet from A5 to E150, I have an area to manually paste in the data (from another workbook). Above that area I have a template for selecting the Prior Month and Current Year using lists. From these lists, the data below (in A5 to E150) should be pasted into the correct month/year in the archive below, as mentioned above.

Question:

How can I create a function in VBA that will paste the data from A5 to E150 into the correct archive area, based on the month/year specified by the user in the drop down lists?

Thanks!

[ExcelFinWizzard]

Edited original post...