I am looking for some serious help to automate certain tasks in Excel. I do a
report for a mailroom and I responsible for tracking and updating certain
functions of our department.

Here is the deal, I have three worksheets, worksheet one has the listing of
all employees information (ie, telephone numbers, building #, etc.) in the
company, worksheet two has all the mailstops for the employees, and worksheet
three is my report. my goal is to find a way to pull inoformation from
certain rows in worksheet one, and in two and have them placed in three;
basically copy and paste BUT i want it to be automated since i update
worksheet one when people move to new locations.

Does anyone have any suggests? if so, can you also give an example for
reference? (and NO not to do my work! =0)

Thanks!