'What's better practice? Multiple IMPORTRANGE formulas OR a single IMPORTRANGE + multiple local VLOOKUP formulas?

What's better?

Method #1 - https://docs.google.com/spreadsheets/d/1JaWUWS3xKOwSX9y7uWUqEU5_Knp8nRgnhlVa1kRNlTo/edit?usp=sharing

Every tab (Team 1, Team 2....) has its own IMPORTRANGE formula in column B2

Method #2 - https://docs.google.com/spreadsheets/d/1uND2IWlMese_ZDH37ITGf2LDwwLriheBbe9ozXAD8Yo/edit?usp=sharing

Import Tab has its own IMPORTRANGE formula in column A2
Every tab (Team 1, Team 2....) has its own local VLOOKIP formula in column B2

Data which is being IMPORTED: https://docs.google.com/spreadsheets/d/1GFnkuE3Dx-rTuvEV6wj1mCEq3P6cOxbzYco4aFVNw-I/edit?usp=sharing

I assume Method #2 would be better, but I just wanted to confirm.

arrays google-sheets import google-sheets-formula vlookup

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source