I need to take data from one sheet and auto populate to a summary page. Date and fill in tab name to populate a dashboard

I am looking for an experienced programmer to help me with a project to take data from one sheet and auto populate to a summary page and date and fill in tab name to populate a dashboard. The data being transferred is both text and numerical data, so the programmer must be able to work with a variety of data types. I have a rough idea of what the layout/design the dashboard should look like, but I am open to suggestions and input from the programmer as to the best way to structure the page and autofill functionality. I need the data to be updated in real-time, so the overall program must be able to do this while keeping the integrity of the data intact. This is an exciting project, and I'm looking forward to discussion this project further with the right programmer.