Hi

I'm looking to specify an excel tab from a dropdown list on a form.

So I have a list of names in a list on a Form in excel. When I select a name. I want that name to be used as Source tab to copy data.
If I select 'Ground work' on the list. I want the code to copy data from the 'Ground work' tab

This is what I have got so far.

BrokerChosen is the name of the list.

Dim Lookup As Worksheet, Main As Worksheet, Import As Worksheet,
Set Lookup = ThisWorkbook.Sheets("Lookups")
Set Main = ThisWorkbook.Sheets("Main")
Set Import = ThisWorkbook.Sheets(FrmMenu.BrokerChosen)