Its all certainly possible and shouldn't be to hard to do providing you have some understanding of VBA and Excel.

I just have two questions
1) Do you need to search through purchase orders for any reason? - sum up the values or anything like that.
2) With the saving to a default folder would it be better to just save all the data into one master spreadsheet instead of having multiple spreadsheets all copies of purchase orders - maybe I'm not being all that clear - I'm just wondering if a record could be kept as just another row in a spreadsheet rather then a total new spreadsheet