Copying data from one spreadsheet to multiple worksheets in another workbook

[Annekennedy]

Good Afternoon,

I was wondering if it is possible to populate data from one worksheet to all subsequent worksheets in a workbook?

In my example I have a Summary Sheet and All of the worksheets are named by their position title. I would like for the user to populate a pop up box with The agency name such as San Diego Housing Commission.
Then the macro would loop through columns B and C on the Summary Sheet and copy to the subsequent worksheets if column B = San Diego Housing Commission, in the subsequent worksheets.

I have attached a sample of a workbook.

Thank you very much for your help.

Anne

[antoka05]

See attached file, I put one orange button in summary sheer.
Please do attention at sheet name on summary sheet because if a name is not equal to the sheet name the code can stop with error.

Regards,
Antonio

[Annekennedy]

Thank you very much Antonio.