need formula to start counting plus 450

I have a if then formula that I have, but I need to be able to change the number it starts on. The formula usually starts at 001, but when I have more than 450 I have to start a new sheet with the 451-900, then 901-etc as I can only upload 450 at a time. Here is my formula, and if you can help me with this

=IF($Draw.$A2>"";IF(ROWS(E$2:E2)<10;$data.$B$2&"_"&$data.$C$2&"_"&$data.$D$2&"_00"&ROWS(E$2:E2);IF(ROWS(E$2:E2)<100;$data.$B$2&"_"&$data.$C$2&"_"&$data.$D$2&"_0"&ROWS(E$2:E2);$data.$B$2&"_"&$data.$C$2&"_"&$data.$D$2&"_"&ROWS(E$2:E2)));"")

mjcloward, please use an appropriate title for your thread, per the forum rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

As per the below from the forum rules can you please rename your thread to something accurate to your thread.

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

EDIT: Sorry beaten to it!

Welcome to the forum, and thanks for the title change

Include a reference back to the previous sheet that looks for the max() value in that column, and add it to the 1st cell of "this" sheet