I've tried for 2 days to figure this out, and I'm usually good at finding formulas online, but I haven't been able to with this one.

I have a workbook with 8 sheets. On the 8th sheet is the master sheet where all the calculations happen.
What I need to know at a glance is if a specific cell on the 7 other sheets match a specific character. This can be a conditional format OR where the cell will fill with the same character.

Example: Cell E5 on sheets 1, 2, 3, 4, 5, 6, & 7 all contain "R". Cell E5 on sheet 8 will change to let me know this has happened. I will actually be using the formula on each line of a column.

Screenshot 2023-04-14 083514.jpg

Can anyone help with this? I would be very grateful!