I am at an intermediate level when it pertains to MS Excel but I am looking for ideas on an efficient way to store, track/report, and update data in excel. Here is my dilemma...

I am a purchaser and I issue many purchase orders for a company that does not have any sort of ERP or database system. I only have MS applications to work with. There are two of us on the team and we each have a different way of keeping track of our purchase orders. So I need to create a tool that the both of us can use and manage our purchase orders and run reports and/or track them. What is the best way in Excel to build a database of our purchase orders, be able to update them as needed, run reports (what is open or closed, show data for specific job names, calculate total spend for each job, etc...), and share this information with others?

My thoughts are to build a pivot table based on information that we enter into a master data sheet. the master data sheet will have the following headers: purchase order number, job name, vendor name, purchase order amount, issue date, and status (open or closed).

What are your thoughts on this?? I appreciate any and all responses.