I need an excel expert

Create a dash board for all projects work in progress, closed, in pipeline, revenue, individual contribution, project working on, overall status, etc..