There has to be an easier way of doing this. I downloaded a text file from
an online source into my Excel 2003 program. The infromation however is
spread across a series of 5-6 worksheets. For example, worksheet one will
tell me the name of the project and give me an ID number and then worksheet 5
will give me the ID number and the contact information. While I would just
sort, copy, paste to have a main worksheet, there are multiple contacts per
project so I've been having to go through and manually match them up to the
proper project. Is there an easier way of doing this?! I was thinking pivot
tables...but I don't think that will work for this. Then I was thinking
queries but as far as I am reading the query only works if the info you
download is in html or some sort of web format or the information is coming
from an external source...but I have all the info now.


Someone, please help!