When I import a CSV file that contains multiple tables, they are lumped together into a single table. ¶

There is no reliable way to differentiate tables in CSV format. For the time being, you will have to break apart CSV files containing multiple tables.