Consolidation of data based on search criteria

[pradeepkodali]

Hello,

I need your help in getting the data consolidated from multiple sheets to one sheet based on the week we select.

For Example: I have sheets named Project A, B & C (Variable) and each has 4 weeks (Variable) data. I am looking for a Macro which should ask for the "week" and suppose if I select Week 1 then it should copy the data from all the sheets of Week 1 to consolidated sheet as shown in the sample sheet.

Thanks in advance for your help!!

Regards,
PK