Open in newest worksheet

[mknowles]

We are envisioning creating a workbook in which each sheet will be a modified version of the previous sheet. For example, sheet1 will be the original version of the data and will be named with the date of origin. For any modifications made to Sheet1, we will create a copy and rename it with the new date of modification. This process will be repeated as additional modifications are made.

I have VBA script that is hardcoded to open in a specific worksheet, but is there a way to open a workbook such that it will always open in the newest, most recent worksheet?

Thanks in advance,
Mike