VBA for month and consolidating data

[Sarah15]

Using VBA, I'm looking to have data brought from sheet(1) to sheet(5) and put under the proper month.
Sheet1 Bring the PO# (Cell H2) and Supplier (Cell E7) to be put in the same cell on Sheet 5 under the correct Month (Jan starts on cell C3, Feb E3, March G3, etc). Date is listed on Sheet 1 (Cell H3). I would like it to use the next available line.

Any help would be greatly appreciated.

 

[Saurabhj]

Hi Sarah, Welcome to MrExcel board.

Please share the Sheet1 and Sheet5 data using XL2BB. It will help us to copy the data in our sheet and to understand the requirement.