Linking multiple worksheets to one summary sheet
 

I am creating a Lead Tracking workbook for the agents that work in my real
estate office. There are 5 worksheets for 5 different types of customers
that we work with in our office. I would like to create a 6th sheet in the
workbook which has all of the contacts on one sheet and would update
automatically. There would be name and numbers. I know about Access,
however, that is far too advanced for my agents to use. HELP!!!!