Hello excel community,

I urgently need your help :D

I have a primary excel table that pulls data from subordinate Excel tables. This works great too, but I always have to open all tables, otherwise I get an error message.
Since new ones are added all the time, this becomes quite annoying.

Is there a way that my primary table pulls the data without opening all subordinate tables?

Many thanks and best regards
nlinder