Extract Table from a Spreadsheet, arrange in various tabs and export to PowerPoint

I need a macro that can extract tables from the attached spreadsheet (sheet name is “sample”) and create multiple tabs with Tab names as the first element of the table and copy the individual tables to separate worksheets as shown in the attached workbook. The first elements from the tables are Table1, Table2, Table3 and Table4.

Please note that in the actual spreadsheet the amount of table are not known. It could be up to 50 tables arranged in no particular order except spaces between the table (I think CurrentRegion should work but not sure) Is this possible?

I was using this line of code in red to select all the regions that I need:

Please Login or Register  to view this content.

Once this has been achieved can it export the contents of the various tabs except the “sample” tab to a PowerPoint if possible?
Thank you so much for the help.

Any ideas please?

You should be able to get the areas like this

Please Login or Register  to view this content.

Thanks Jindon, how can I move the areas to other tabs in the spreadsheet individually?

If you want to copy/cut

Please Login or Register  to view this content.

?

Perfect! Thanks a lot Jindon, one more thing, how can I move the copied areas to PowerPoint slides? Is that possible?

I don't use PP, so ask someone else.

Thanks a lot Jindon....your help has saved me hours at work. You are awesome !!!

Jindon, I noticed that in my spreadsheet, sometimes the line

Please Login or Register  to view this content.

returns same address multiple times for a range that has spaces in them. Lets say they area (From cell A2 to B14 in the attached spreadsheet) has some spaces in ColumnB, it returns $A$2:$B$14 several time until all the spaces are counted. Is there a way I can modify the code to use System.Collections to collect the areas (so that it won't repeat an area that is already reported) and then dump them out on whatever sheet I want.
Thanks for your help

I was able to finally modify your code to be able get it right as you suggested. Thanks for your time. I will mark this thread as solved now