Turning 1 workbook link into a table

[Vbanoob98]

I have 200 links to different workbooks that I need to turn into tables/data.

=+'https://onedrive.com/Documents/[File1]Sheet1'!E1
=+'https://onedrive.com/Documents/[File2]Sheet1'!E1
=+'https://onedrive.com/Documents/[File3]Sheet1'!E1
...
=+'https://onedrive.com/Documents/[File200]Sheet1'!E1

I need columns E:G. So the table would be from E1:G100.

I know I can drag each one to the side and then downwards but its going to take too long. I also dont know if its better to have each link create a table in a new sheet or everything in the same sheet. It would be nice to have at the beginning of the data the name of the file. I'm researching loops at the moment as I feel that might be the best way


Thanks a lot guys!