split Tables into multiple Tables for multiple sheets with different structure & arranging

Is the tt sheet changes everyday ?

every month

- but hoping there are only 3 sheets and that will never change ?

no there is more but I gave you 3 worksheet as in example and could be change but this case is really rare.
usually the PDF files contains two pages or more with different structure when convert to excel .

but according to your small data attached workbook the result should be instant …

yes that's correct , but as I said this case could be rarely, but this case is not problem then I have to import data again from PDF files .

But o b v i o u s l y rather than such gas factory VBA procedure as the import is not correct - no sense to mix data like that ! -

as in title of thread with different structure . if it's not different structure I didn't post this question here and this happens when convert to excel data to become like this way.

the appropriate way is to import only one file directly to its relative worksheet

I agree with you , but this means arraigning manually one file by one for many files and it takes more time to arrange each sheet.

You wrote « the macro doesn't create sheets automatically » but you yet answered « absolutely yes » for the before state
so meaning no need to create it ‼

misunderstood I thought you're talking about the PDF files , not sheets ,sorry !and this isn't big problem I will create manually.

You wrote « will change data from TABLE to range » but o b v i o u s l y your attachment expected result contains
a sheet with no table, your bad !

no way ! attachment is TABLE and when I said will change data from TABLE to range to John because of b v i o u s l y can't deal with TABLES and I don't make hard the matter for him but based on attachment should be as TABLE.