Look up Data by month copy and paste

Good Afternoon Everyone,

I am having trouble getting a macro to work correctly, I currently have a macro that will take the date in cell R4, find the corresponding month in range D8:O8, and copy and paste the data to cell P9. I am now trying to do something similar with cell R4. I have set up two more moth heading in Q24 and R24. the dates adjust based on the data in R4.

So what I am trying to do is take the month in P24, find the corresponding month data in row 13 and paste it in Cell P31.

Any help ould be greatly appreciated.

I never considered an HLOOKUP for this, I use VLOOKUP a lot, but have never utilized teh HLOOKUP, that you for the help!!