Curious about connecting Excel files!!!

I'm using it by connecting files in Excel. I am using a file called "A" by connecting it to "B". If the "A" file is on the USB and the desktop, I wonder if the "B" file can automatically connect to the "A" file, which is located close by.