I am working on a workbook that has multiple sheets. There are a few columns that are Y/Ns. I was trying to pull entire rows from other sheets based off of a Y/N drop down list, so if I needed to know what reports have certain terms hardcoded, I could get an entire aggregate instead of going to each tab and filtering. Is there a way to do this?

I have tried different variations of the INDIRECT formula, but I am having trouble pulling complete rows of data, including from multiple sheets.