Find values in another sheet by column header
I import data from other spreadsheets and then process that data in a new sheet. The data comes in different formats every time, but the column headers are always the same. In other words, the columns are always in a different location, but the first row of the column is always the same. I'm looking for a way to get the data I need in a formula that is automated. Following is what I've been able to figure out on my own, but it's a long convoluted mess. I'm looking to simplify this formula, any help will be greatly appreciated
=XLOOKUP(G$2;INDIRECT(ADDRESS(1;MATCH("ASIN";'Import - Top Products Results'.$A$1:$Z$1);1;4;"'Import - Top Products Results'")&":"&ADDRESS(1000;MATCH("ASIN";'Import - Top Products Results'.$A$1:$Z$1);1;4));INDIRECT(ADDRESS(1;MATCH("Thumbnail URL";'Import - Top Products Results'.$A$1:$Z$1);1;4;"'Import - Top Products Results'")&":"&ADDRESS(1000;MATCH("Thumbnail URL";'Import - Top Products Results'.$A$1:$Z$1);1;4)))