In one workbook, I have a column A which A1 contains "Cities". In another workbook there is a "Cities" column, however, it's not in a static position. Is there a formula that I can use to look across Row 1, find "Cities", and list all the not empty cells in that column on my local workbook...