Patient visit dashboard

I need a spreadsheet that I can enter small detailed on the cells and then automates the data to be transferred to a dashboard. Also separate sheets for database for reporting purposes.