Creating multiple tables in a single Date from Table operation in Excel

I have a large table containing data which I need to split.  I currently do this by using the Data From Table option, then filtering the data to create a new Table only containing the filtered data, ...