How do I copy information from multipule worksheets to one worksheet?

[Tanya0979]

Hi all,
I am doing work around assessing our staff skills and how competent/ confident they are for each skill. The information is broken down on individual worksheets for each location but I also want particular information to copy through to a master sheet. Is this possible?
Below is how each sheet is set out but of course the names change on each sheet. Also we only want the Competent, Confidence and experience information to copy through to the mastersheet along with the headings and skills etc.

Can anyone offer any advise to make this easier than copying and pasting everything.

		Joe Bloggs	Wilma Flinstone	Minnie Mouse
Playing in water	Competent Yes/ No
	Confidence Level 1-4
	Experience (yrs, mnths)
	Formal training
	Comments
Building Sandcastles	Competent Yes/ No
	Confidence Level 1-4
	Experience (yrs, mnths)
	Formal training
	Comments
Making Mud Pies	Competent Yes/ No
	Confidence Level 1-4
	Experience (yrs, mnths)
	Formal training
	Comments

<tbody>
</tbody>

 

[ranman256]

You actually would want to store your data for PC use. (the above grid is good for human reading but not PCs)

like:

PERSON	SUBJ	Q	A
Joe Bloggs	Playing in water	COMPETENT	YES
Joe Bloggs	Playing in water	Confidence Level	1
Wilma Flinstone	Playing in water	COMPETENT	YES
Wilma Flinstone	Playing in water	Confidence Level	3
Joe Bloggs	Building Sandcastles	COMPETENT	YES
Wilma Flinstone	Building Sandcastles	COMPETENT	NO

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

THEN you can arrange the data to view via PIVOT.
If every sheet is entered as yours, but for 1 person only, then collecting the data will be possible.