I'm currently editing an excel file for my boss where I'm inserting a bunch
of VLookup functions in order for data to be automatically entered. However,
the file from which I'm getting the data is most likely in a different spot
on my computer than it is on my boss'.

Will there be a way that I can change ALL of the VLookups at once to have
the new file name once I transfer the file back to my boss?