Please help. I have a macro that pulls in a text file.

This file has over 65,000 rows. The data pulled fills down sheet 1 and then once 65,000 rows is reeached a new sheet is inserted.

Once this new sheet is inserted how do i get the macro to activate this new sheet, and continue to fill in the data starting from cell A1 again.

please help