Copy live data from certain columns from one sheet to another

I have a very large sheet with 58 columns and over 3,000 rows but continually adding until it gets full them with push to a new sheet. Anyway I want a new sheet that references the data in only a few on the columns in the primary sheet. I tried using INDEX function but I'm unable to get it to work. Is this the best option. I don't think V-lookup will work since all of he columns are in random areas of the current sheet. I have attached a screen grab of some of the columns I want to see in the new sheet.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!