Automatically sort a workbook on opening and delete blank rows.

Hi All,

I am trying to educate myself in the wonders of Excel (2003) and an struggling somewhat.
I have a small project loosely based on a shops stock control and have attached a copy of the workbook - if it helps.

The user normally only has access to columns B, C and E due to the others being locked and the sheet protected.
I would like the sheet to be automatically sorted based on column E each time the workbook is opened.

I then need to automatically delete a row once an item in column B has been removed (made blank)

Any help would be greatly appreciated

Drew