Purchase order spreadsheet with two templates and summary

I am a volunteer with a small landcare group and the officers have asked for a Purchase Order spreadsheet with some specific features. Being a bit of a dunce at VBA I am having trouble writing the macros for the project and would be grateful of some help with spreadsheet. I have been able to get the point where I have done the formulas, and the easy macros for some buttons.

I need help with macros to open the Summary at the last entry, a macro to open a new PO from one of the PO templates sheets, a macro to add the next number to the selected PO and a macro to open the print dialog, select Adobe PDF and open the Save as dialog. Automatically make the PO number a hyperlink that opens the PO.

Thanks for reading my post and hope you can help me.