Specify a tab from a dropdown list

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.

Please Login or Register  to view this content.

I have no working copy. Sorry, let me explain a bit clearer.
I have 5 tabs in excel. Called 'Ground', 'Air', 'Sea', 'Land' and a Final tab called 'Main'

I have a userform with a drop down list. This List has the tab names, So Ground, Air, Sea, Land.

When I select 'Ground' on the userform dropdown list it sets this as the sheetname So the code know it needs to look at the 'Ground' tab.

hardcoded would be Set Import = ThisWorkbook.Sheets("Ground")
but I need the name (bold) to be Dynamic because it could be the following, depending what was selected on the list.
Set Import = ThisWorkbook.Sheets("Ground")
Set Import = ThisWorkbook.Sheets("Air")
Set Import = ThisWorkbook.Sheets("Sea")
Set Import = ThisWorkbook.Sheets("Land")

Thats why i was thinking

Set Import = ThisWorkbook.Sheets("Name selected from list")

Perfect. Thank you. That was it. I was missing .Value