We have put together a roster workbook in Excel 2003 where each of our
workers have a seperate worksheet for their roster. Each worker has specific
clients that they see on certain days of the week, so some columns are left
blank on the days/times that they do not work (i.e when they are not visiting
clients)

What we are trying to achieve is a summary sheet which lists all of our
clients and the employees that go to them on specific days. As it is a whole
workbook, pivot tables won't work, and the formulas we've tried (VLOOKUP and
MATCH) are not yeilding any results.

Is there some way to automate this process without having to manually update
the data?