Hi there.

Is there a way to bring Sheet 1 from File A in to Sheet 1 in File B without
utilizing the move or copy function and without writing a formula for each
cell you want to bring in?

Strange question, I know.