Column data changes everytime however column name remains same.....

[harinsh]

Hello Team,

Hope anyone can help with below query....

I have input data however data columns may change everytime (Header name will not change) for example if I have Customer Name in A1-column next time Customer Name column may get in C1-column.

I have one macro where will refer these data sheet....everytime need to change the reference.

Can anyone help in how to take entire column data going by column name instead of reference.

Thank you,