Thanks Richard,   I have a collection of pages for each department at work: parish staff, school staff, maintenance, educators, substitutes.  On each page I have their name, date of hire, w-9, health insurance etc columns listed. The heading columns are identical on each departments page.  I would like to have a first page that is simply listed as employees. This would have all of the employees listed by name with all of thier information.  My thought is to be able to update the departments information and have it automatically reflect on the total employee page.  

I hope this helps explain my needs.  I am loving the excel expert course. Even though I have worked with Excel for years, I am learning such great little tips!

---

Reply from Richard Rost:

This is exactly what VLOOKUP is good for. You can create a summary page with ALL of your employees listed, and just lookup the information from the individual department pages. There a free TIP video online that covers the basics of VLOOKUP, plus I cover it in depth in Excel Expert Level 4.