As welshman suggested, I would lean towards renaming the tables with a prefix of their date in "yyyymmdd" format. Then they will be in order when sorted alphabetically.
However, Micron also makes a good point - if you have a bunch of tables that are all structured the same, but just with different dates, it sounds like you have a un-normalized database, which is going to make it a pain to work with. In a normalized database, you typically do not have multiple similar tables with the same structure. Your database structure should not change all that often, just the table in it, so you do not need to constantly create new queries and reports.
In a normalized structure, you would probably only have one table that stores all this data, and the data would have a field for the creation date, so you can easily differentiate all the data. So you would import all your daily data into this one table.