Thank you all for your replies!
@ipazin Thank you! I would hope for a quicker solution for such a simple task though.
@Daniel_Weikert and @mlauber71 I think this is the right direction! I cannot remove the empty rows below, because they’re not empty (meaning I have a table above and another table below).
However, the table I need occupies the same cell range in all files, always in the first sheet.
I can definitely exploit this! I guess I must just learn how to store the first sheet name as a variable to be able to read from the first sheet no matter the name (the first sheet’s name is not always the same in all files).
It wouldn’t be bad to be able to exploit the fact that tables are named ranges though…that would make everything way faster!