=IF(ISERROR(OFFSET(Beijing!$A$6,SMALL(IF(Beijing!$C$6:$C$152=$E$3,ROW(Beijing!$C$6:$C$152)-MIN(ROW(Beijing!$C$6:$C$152))+1),ROWS($1:1))-1,0)),"",OFFSET(Beijing!$A$6,SMALL(IF(Beijing!$C$6:$C$152=$E$3,ROW(Beijing!$C$6:$C$152)-MIN(ROW(Beijing!$C$6:$C$152))+1),ROWS($1:1))-1,0))

This code is functioning exactly how I would like it to. It is creating a list by taking a value from the dropdown list in cell E3 and providing the corresponding values based on the selection in E3. I am wondering if I am able to add more information from other worksheets to this list based on that same value in E3. There are 2 other worksheets that have similar data to extract based on the same value in E3.

I simply want my list to expand to include the data on 2 other worksheets.

Is this possible without VBA?

Thanks so much in advance!!