yeah, far as I can tell, the sheet names can be whatever. Basically, let's say the Excel file is called Pets_01012019. Within that workbook, there is a worksheet 'Cats' and another 'Dogs' Lets say within those worksheets there is PetID and PetName. After running the package, the table now has these fields with these values (sorry, this will look a bit scrappy...)
PetID PetName FileName SheetName
1 FiFi Pets_01012019 Cats
2 Fluffy Pets_01012019 Cats
3 Rover Pets_01012019 Dogs
4 Fido Pets_01012019 Dogs
...I just can't understand why this works great until I try that Excel file.... it's like it's poisonous. I can even create my own file, and even the headers, but as soon as I paste the data, it goes awry. BTW, I did try renaming the sheets after the C & P to no avail
thanks again for the help!