Chuck Hague wrote...
Thank you for responding. Guess I will have to try another tack as I have
thousands of cells which would require these significant unique workarounds.
....

Actually the first alternative would be the best approach if the data
in the other workbooks were mostly unchanging.