I believe this takes me into the VBA realm and that is uncharted territory
for me. Here we go: I have 10 pivot tables in workbook A on worksheet 1. I
need these pivot tables to refresh whenever cell R1C1 in workbook B on
worksheet 2 changes. I need this to be done without having to have workbook A
open (it is very large). Please advise.

Thanks!