Pull tab from desktop folder

Happy holidays everyone - I have a problem with VBA, and it's pretty much that I'm illiterate. I'd love if someone could help me write the code necessary to do the stuff in Bold. The first note is just the task the users will have to do, because I don't think it can be done with VBA:

1. Download/save the files from SharePoint to downloads folder (password required) - this can't be done with VBA, right?
2. Copy a specific tab from each file (let's call them Tab 1 for File 1, Tab 2 for File 2, and Tab 3 for File 3) into the Master File.

Let's assume this is the folder path:
C:\Users\excelnoob927\Downloads

What happens when other people download it to their computer? Will they have to submit the folder path? Is there a way that a form/input box can populate so that they don't have to go and change the code? Or is this too much work. Most of the people that will be using this are even more illiterate than I am (they have never heard of VBA).

Is there maybe a better way to go about this?

Thanks,
Excelnoob927