Copy Columns to another sheet based on column heading

[jhall488]

Hello All,

Does anyone have an idea on how to copy columns based on a Client's file. I receive files from different clients and the headers are all different. I need a way to copy each column that wont be in the same position from the clients sheet to my generic sheet. I know that I could create a macro for each individual client and run accordingly but i was trying to clean this up a bit. I was possibly thinking about having a table with client name, their field, my field and copy columns. If there is an easier way that would be great.

I have attached a sample work sheet with my table idea.

Thanks for your help