Data in different columns

[Carlyn]

Hi,

I am inputting data from multiple tabs and due to a specific column name being different on each of the tabs, I need to find a way to pull the data in each of these columns into 1 column. I have tried using a text input to recreate the issue which you can see in the attached workflow. I have used a formula where I have successfully pulled the relevant data from each column into a new column called Join

The formula is  [USBDA]+[USCGM]+[USCICA]+[USSWISS]+[USINTL]

However, the live file that I will be using will have over 30tabs and the column names may change occasionally so I am wondering if there is an easier way to do this.

[alexnajm · Accepted solution]

This should do the trick!