I'm a novice Excel user...

We have an spreadsheet that we have several seperate worksheets for each day's worth of information. We have multiple clients that show up on different days throughout the five different worksheets. We'd like to somehow coralate and collect onto one view what clients show up on what days in a single view.

Any thoughts on how this can be done? Thanks!