VBA Vlookup or another best option to copy from a filtered sheet columns to other tabs?

[Melimob]

Hi there

I have some imput data sheets that will be filtered by country.
Using what's filtered, I need to populate that info into other sheets.

At the moment, I am using VBA to populate one column, then within that sheet, I am just doing vlookups but I wonder if there is a better way to do this all at once?

Sub GetClientData()'
' GetClientData Macro
'


'
    Sheets("ImportCCB").Select
    Range("Table10[Control Centre Company Build]").Select
    Selection.Copy
    Sheets("ABC Clients ").Select
    Range("C3").Select
    ActiveSheet.Paste
End Sub

Then my vlkups are

Header Table name: In Control Center
=IFERROR(VLOOKUP(Control_Centre_Company_Builds,Table10,26,0),"")

Header Table name:Company ID
=IFERROR(VLOOKUP(Control_Centre_Company_Builds,Table10,4,0),"")

I have many more also.
I would prefer to match on header table names and the values in Table10[Control Centre Company Build] incase anything is moved around.

Any advice gratefully received.

Thank you in advance!