Excel Macro

[Jaredhott]

I made an excel sheet that has 5 tabs. I put info in one tab and the others pull information from that tab to populate cells. That way I don't have to type things in multiple times like address, name, etc. This is working great. To make this even better I was wondering if there was a way to run a Macro that would do a save as of the document to a certain folder using the last name of the person? Additionally, a couple of the tabs only pertain to certain types of people based on the state they live in. Would it be possible to code something that deletes 2 tabs based on the state that is input into a certain cell. Thanks.