Hi everyone

I need some help please, what I have is an excel document that has a total of 5 sheets I am trying to get the first Sheet to display all the information from the other sheets(Auto update).
All sheets have the same heading in the first row but the first sheet has one extra heading.
The extra heading is title which is meant to be the title of the sheet it has got the information for.

so
{Sheet}--------------{headings}
First----------------Title, name, age, address
Second------------Name, age, address
Third----------------Name, age, address
Forth----------------Name, age, address
Fifth ----------------Name, age, address

so information from
Second sheet is
(A,2)=Peter (B,2)=18 (C,2)=231 st

Third sheet is
(A,2)=Betty (B,2)=18 (C,2)=May st


I want it to automatically update into the First sheet as
(A,2)=Second (B,2)=Peter (C,2)=18 (D,2)=231 st
(A,3)=Third (B,3)=Betty(C,3)=18 (D,3)=May st

this is just a quick example to give you guys an idea of what I am trying to do any help would be greatly appreciated

Thanks for any help.