How to get only the top row from multiple tabs into a new tab?

[Angeljot Dhng]

I have multiple tabs of each city which include the information of that specific city. The question is I want to fetch only the top row from each city tab into a new tab that includes city names that are unique.
Example: I have three tabs of cities say NY, DC, and Chicago, each contains information about that particular city. I have made a new tab (let's say the name of the tab is tab_city) with only 1 column (cities) which includes city names NY, DC, and Chicago. I want to fetch only the topmost row of each city from the multiple city tabs into the tab_city tab. Is there any function/formula which does it dynamically like if I drag the formula in the tab_city, automatically the information(only the top row of each city) of other cities comes?
Thank You
PS: If the description is biased, the below link will lead you halfway. Visit:

 

[KRice]

Here is one approach, although it uses volatile functions that can cause slow performance if the worksheet is large. This assumes you'll populate column A with the city names that exactly match the tab names. Then drag the formula to the right until it's captured the entire row. You may have to adjust the references depending on which column holds the first value of interest.

MrExcel20210225.xlsx
	A	B	C	D	E	F
1	cities
2	NY	1	2	3	4	0
3	DC	11	12	13	14	0
4	Chicago	101	102	103	104	0
tab_city

Cell Formulas
Range	Formula
B2:F4	B2	=OFFSET(INDIRECT("'"&$A2&"'!$A$1"),0,COLUMN(B$1)-COLUMN($B$1))