Problem with Formula based on Data Validation Selection from multiple tabs

I have 15 locations listed on their individual tabs. Each tab has the same format but different data (except the dates column, they’re the same on each tabs). On each tab, I have a growing inventory list.

- Dates are listed under Column Y. The first date is Y5.
- Items are listed under Column Z. The first item is Z5.
- Action Notes are listed under Column AA. The first action item is AA5.

On a separate report tab, I want to create a spreadsheet that will toggle back and forth between the selected locations. For selection, I use a multi-level data validation.

On the report tab, once a location is selected,
- Dates will fill in at T12
- Items will fill in at U12
- Action Notes will fill in at V12

However, my function keeps returning “#REF!”

Formula:

Please Login or Register  to view this content.

All help is much appreciated! Thanks!