When using the Indirect function, how do I look for a tab or sheet that is in
a different Excell file. In this case,

INDIRECT(A4&"!b5") if in AR4, summary is typed then the formula will
look for the value that is in b5 from the summary Tab or sheet. but what if I
am interested in a Tab that is in a different file?

Pester