Selecting multiple files by browsing at once

[vinmam123VBA]

Hi Friends,

Can you please help me with VBA code where I can select Multiple files at once by Browsing.

For example-
I have four files in one folder. Below are the file names(File names keep changing)

1.Source1
2.Source2
3.Source3
4.Source4


I need trying to come up with options where I can Browse and select these files something like below
Select file 1 -- Option to browse and select one file
Select File 2 -- Option to browse and select second file
Select File 3 -- Option to browse and select third file and so on
After these I need to make Changes in the files. For that I should be able to select the opened file through variable name(Because file names keep chaning)

For example-
Once I open all four files If I want to go to sourcefile3 and make some changes then I should be able to do it by activating this file by variable name

Regards,
Vin