Here's my situation. I have several Excel files that are downloaded from a
website daily. These files have any where from 1 to 6 tabs in each file and
NEVER exceed 5,000 records per tab. Meaning the most records downloaded
would never exceed 30,000. Each day it's different though, one day it could
be 3 tabs the next day it might only be 1.
How would I be able to import these automatically into another Excel file
and have the code look at all the tabs that are within the downloaded file?
The range would always be columns A - AK and as stated, would never go beyond
5,000 rows per tab. It's just the number of tabs that's changing.

ANY help would be so greatly appreciated!!! Thanking you in advance for
your valuable time!!
JCarter