Need Help with writingg/editing VBA for User drop down List in Excel 2010

[powella9]

I need some help in writing vba code in Excel 2010.I am a novice at coding. I inherited a macro that let the user select a factory from a drop down menu. After user makes a selection, a button is click to execute the macro. The macro does a series of copying and pasting data to update a series of charts. Then all sheets are hidden except the sheet containing the charts. The charts sheet then saved to a separate folder with a different name on network and it closes. The problem is that the user has to individual select about 60 factories and run macro. This is very time consuming. I am looking for help in constructing a VBA code that let the user run the macro with one click of a button. I still need to be able to hide all datasheets after copying and pasting the data for each factory except for the chart and save each factory with it unique name.