Cosnolidate multiple sheets into one sheet

[sunny81]

Hiya,
I am very much new to excel forum and new to VBA too. Need one help. I have one excel file with around 40 sheets. Each sheet has same number of columns and rows. I need to copy the data from each sheet for selected month into one sheet in same file in a particular format.
I have attached the excel file for quick reference.
You will see there's a sheet called "Launchpad", where from row 23, month and year name is mentioned. you will see that from cell C23 downwards, "Y" or "N" are mentioned.
So if a cell from C23 states "Y", it means look for the period combination mentioned in column G in "launch pad" sheet and then go to next sheets, look for the same period combinations, copy data into sheet name "Upload format" as follows:
in column A - Cell B12 to B161
in column B -Cell C12 to C161
in Column C - Cell D12 to D161
In Column D- Amounts for the look up columns as per selection "Y" in launch pad
Column E- Cell F1 from Launch pad
Column F- Data from Cell H23 onwards for each Y selected
Coumn G- Data from Cell F23 onwards for each Y selected
Column H- Data from Cell E23 onwards for each Y selected
Column I- Cell C8 from Launch pad
Column J- Cell E1 from Launch pad

Thanks again for this wonderful forum.