Fetch Data: Return Multiple Rows based on Cell Content

[pdreyest]

Hi there!

I am posting the example attached. If you see tabs "US" and "Jap" you will see a few users. The raw tab has all the data available. I need a formula/funcion (or even Macro as I cannot wrap my hands around the best way to do this) that will return all the rows based on the users in tabs Jap and US. If you need more info on the case, this is to determine user errors.