I'm running Excel 2007 on my laptop, with default configuration. At the bottom of my spreadsheet are Sheet 1, Sheet 2, Sheet 3. To the right of Sheet 3 is a new button for Insert Worksheet. This inserts a new Sheet 4 to the right of Sheet 3.

Clearly the problem is finally fixed. So quit yer whining, it's an excellent product!