Project workbook sheet issues

[ts656577]

All,
I've been working on this sheet for a little while now and had first released a copy to some guys in our group. They've come back with some questions and rightfully so. The big issue was that I developed it based on a large project I had at the time and knowingly knew it would need updating because my list of equipment items (column A) of the equipment plan tab were more specific to my project. It however does not represent every project. Some are smaller, some don't require all of that equipment, some require more or different equipment. I had the idea of adding a "Project Scope" tab in which a user inputs all of the equipment or items that needs to be accounted for in the project. I was hoping with the press of a button it would auto populate the equipment plan tab, but additionally name the vendor details tabs.

It's a little confusing in this text but I created a word document with some pictures to help explain what i mean. I'm mediocre with excel at best but I really want to streamline and clean up this process some more. Any help would so greatly appreciated.

[ts656577]

Files are attached I hope