How to manage vendor data?

I work in the Procurement Department, and our company has a total of eight manufacturing units. I need to create an Excel sheet that contains a database of different vendors for various raw materials. In Sheet 1, I would like to have a quick summary dashboard showing all open Purchase Orders along with a section to track and follow up on dispatch details. Please suggest ideas on how I can make the sheet well-structured, easy to use, and visually engaging, as I am a beginner in Excel.