Macro to search the sheet name and copy and paste the data from a major sheet

I have an excelworkbook which has n number of worksheetssheets in it.

I have major sheet which has information pertainning to all the n sheets.
Now what i want to do is copy the particualr information from the major sheet to the particular sheet.

For Example i have ten different manager worksheets . The major sheet contains the data for all the managers.
I want to copy the filename of each manager and search it in the major sheet and copy the information related to him to his sheet.

Attached is the example.

Please help me on this its very urgent.

Thanks,
Salma

Hi
It is not clear from the attachment, which info you wish to copy from Major sheet to each manager's sheet
Ravi

Hi Ravi,

I want to copy the information related to each manager from the major sheet say in the attachment i want to copy the the data from A2:c5 for the first manager similarly a6:c6 data to second manager sheet.
I will have the horizontal rows to differentiate the data in major sheet.
I hope the information is clear now.

Thanks,
Salma