Listing info by using template...

I not sure the title tells much about my problem/challenge, but anyway...

I have an Excel sheet with a lot of worksheets (have enclosed a small example). In that sheet is a project template. Each time we have a new project, the sales responsible copies the content from that template into a new worksheet - renames it with the name of the project - and fills in the requested information (see example sheets named: Project A and Project B).

What I would like is that all the information from the various project sheets is automatically transferred to the sheet named List and all I have to do is type the name of the project in the first column and then rest rest of the information is copied automatically from the relevant project sheet. Is this possible - and if yes... How to...??

Any help would be very much appreciated...

Brgs Eva