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.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Joe Bloggs[/TD]
[TD]Wilma Flinstone[/TD]
[TD]Minnie Mouse[/TD]
[/TR]
[TR]
[TD]Playing in water[/TD]
[TD]Competent Yes/ No[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Confidence Level 1-4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Experience (yrs, mnths)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Formal training[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Comments[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building Sandcastles[/TD]
[TD]Competent Yes/ No[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Confidence Level 1-4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Experience (yrs, mnths)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Formal training[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Comments[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Making Mud Pies[/TD]
[TD]Competent Yes/ No[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Confidence Level 1-4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Experience (yrs, mnths)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Formal training[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Comments[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

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

like:
[TABLE="width: 480"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]PERSON[/TD]
[TD]SUBJ[/TD]
[TD]Q[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Joe Bloggs[/TD]
[TD]Playing in water[/TD]
[TD]COMPETENT[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Joe Bloggs[/TD]
[TD]Playing in water[/TD]
[TD]Confidence Level [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Wilma Flinstone[/TD]
[TD]Playing in water[/TD]
[TD]COMPETENT[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Wilma Flinstone[/TD]
[TD]Playing in water[/TD]
[TD]Confidence Level [/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Joe Bloggs[/TD]
[TD]Building Sandcastles[/TD]
[TD]COMPETENT[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Wilma Flinstone[/TD]
[TD]Building Sandcastles[/TD]
[TD]COMPETENT[/TD]
[TD]NO[/TD]
[/TR]
</tbody>[/TABLE]


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.