Is there a way to query multiple (100) tables at once?
I thought about doing that, but I need all the information separated as it needs to be analyzed day...

Thanks to you both for the quick responses 🙂

Cheers Jacob Wilkins, that produced results exactly how I needed them.
Such a simple fix, I knew it was going...