Excel Macro (VBA)

Attached is a template I would like you to create a macro on. Objective is as follows:

Main worksheet contains a drop down box whereby the user can determine which worksheets they would like to export.

Setup worksheet contains the export location and export name

The following worksheets contain data that the user will enter (port, share, index, benchmark, port config, composite, comp_memb, comp bm assoc). Cells highlighted in orange require the user to enter in free text. Cells highlighted in blue is based on a drop down box That reference the "mapping" worksheet.

The following tabs (wrk_port, wrk_share, wrk_index, wrk_benchmark, wrk_port config, wrk_composite, wrk_comp memb, wrk_comp bm assoc) have been created as lookups. I would like you to paste the codes from column A that have been entered.

For example "port" worksheet Column A to be pasted into "wrk_port" worksheet. And the formulas to be dragged down. This data then needs to be exported to the location stated on the setup tab.

I would like all the wrk tabs to be cleared (keeping the formulas) when each export is run.

Let me know if you require any more information.

Can you please provide a quote.