Moving Data between sheets in the same workbook and moving data between Workbooks.
 

My husband and I are creating a spreadsheet to use for our car shows. We
have several classes on different sheets and a main information page and a
winners list page. We need to move the competitor number and name to the
specific sheet for the class if that class has an x in the box for it on the
information sheet. Then after the scores are entered on each class sheet, we
need to move the name, competitor number and place to the winners list. That
is the first question.

The second question is: we have PDAs that we are using for the judges to
enter the competitor scores into. We have the program to transfer them form
the PDA to Excel on our computer but now we need to be able to input those
scores and competitor numbers into the main workbook on the correct sheet
for each class. Please Help. We have been working on this for 2 months now
and still can't get it to work right.

url:http://www.ureader.com/gp/1042-1.aspx