How to create auto populating multiple sheets based on cell

Hello,

I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I select the data from the drop down list.

For example:
Building - 123 Simcoe St. has 5 meeting rooms on 1st floor
On the excel spreadsheet, I have the drop down list to select the building and floors. Once I selected 1st floor, I wanted to have 5 sheets (same format) auto populate out at the bottom to fill out.

Is this doable?

Thank you for all your help!!!!