I know this thread is old. What you have here works great other than one little hitch. How would I exclude the sheet that the view is actually on? I’m getting all the sheets the view is referenced from, but sometimes, for some reason, it includes the sheet it’s hosted on.
In @rdeardorff 's example, S20-302 would be in the SHTS REF list.