vba only import columns from csv with specific text in row A

Hope you can help me how to code the following
How to import a csv file where it should only import only columns with a specific text (header) as it can sometimes differs from columns

Eg in cell

A1 Client Name
B1 Contracted
C1 Address
D1 Sales
etc
Lets say I want only the columns Client Name, Sales. Etc imported to save speed and space

Can anyone help me pls?

Thanks