I have 5 sheets that all have an ID field in column A that I want to filter on. I want to filter the 2nd,3rd,4th, & 5th sheets after I filter for a specific ID on the 1st sheet, and if i filter for an ID on any of the 5 sheets it will filter for the same ID on all the other sheets. These 5 sheets are not the only sheets in the workbook, as I have 2 other sheets that are not like the others at all and dont want those filtered.

I was told by a peer that VBA does not need to be used to solve this problem, I know VBA will solve it but I dont want to go down that path. Will power queries, advanced filters or hyperlinks help solve my problem? I've been researching how to do it without VBA for about 2 hours now and I've given up.

Let me know what you guys think is the best and most efficient way to solve this problem. Thanks!