Working with multiple excel files as data source

I think I've run into this same issue trying to use the network drive folder holding several excel files as a source but I don't know if it is possible. The solution I had to settle on (unless someone has a solution here) was to upload each excel and append them into an already existing excel data source within Power BI.

In my case it is a weekly dataset I have to pull from the servers then upload into Power BI so I do get data > select the new excel > upload > edit queries > append and then select the original file you're appending into and then it appends the new excel into the full appended excel using all the previous weeks. 

It works well enough and the process only takes a few minutes plus all my conditional columns, grouping and measures are still in place from the primary excel source that is being appended into.

Hopefully I am still working inefficiently and someone has a work around to automate this better for both of us in this situation.