That is not a free question. We are volunteers. I would recommend that you perform the follwoing, and go from here:
Write (record) a macro that take the current tab, copies it, and moves it to the end of the book.
Write a macro that starts a new tab. PLace the current data conection, onto the new tab.
Do that, and post back if you have any issues tieing them back together in a scheduled task!