GETPIVOTDATA vs. INDEX/MATCH

Hi all,

What is the best and most efficient way to retrieve attributes for every corresponding item from the data tab which is refreshed daily. Put everything in a pivot first and then INDEX/MATCH it from there? or get it directly from the raw data tab?

The information is constantly changing, columns are added and removed, attribute names change here and there... so I guess pivoting everything first would give some more stability? Is there a way to use GETPIVOTDATA to get the attributes for each item number? Or can it only be used for the metric columns?

Also, if items are added daily in the data sheet, is there a way to automatically find them and add them to the bottom of the list in the Range sheet table?