I cannot see what I am missing with this one so any help is well received.
I have 4 Excel Files in a Folder that I want to Consolidate into a Single file. Each of those Excel Files will have a single Table but I cannot guarantee that the table name will always be the same. Have you seen any examples of how I can resolve this. I would also like to have the Filename as Column within the Consolidated Table but I only seem to be able to do one of the Other.