Custom Auto sort columns on open

I've got a template that is used to export a report from our accounting system. It has information about purchase orders e.g. PO number, supplier, product etc. (a sample is attached as i was unable to attach the template)

I've created Sheet2 which shows the information from sheet1 (the is the only way it works with the accounting system).

My issue is that I'd like to automatically sort the rows in Sheet2 when the template is opened, first by supplier, then by PO number, and then by Date promised. (ascending)

I would also like to exclude or hide any rows where 'product' is blank (or 0) or at least push them to the bottom.

Can you please let me know how i can do this, keeping in mind that the file must be saved as a 1997-2003 excel template.

Regards

Peter