Excelsheet help

Job ID: 34838727

Budget: $12 – $30 SGD

I need someone to teach me in english without coding and done it automatically using excel
E.g summary (i also have the address located at b1)
I have different name tab e.g company in there e.g c1 is the address, everything inside is fix row and column, e.g name date

How can i do such that if in the future i create a new tab e.g company b it will automatically display the thing i want address,name, date at the summary page without clicking each and every individual tab to find out the detail

NEED IT BY TOMORROW