Pull Data from one workbook to another

I'm new to this forum and I did search this topic. Some of the topics were similar but complex for my situation (i think).

I want to use one main worksheet for each of my clients and have certain information pulled into another worksheet (one for each of my clients).

I want to basically copy names and dates from one worksheet the second worksheet. The first worksheet will change throughout the week. For example, I may have one person on the main worksheet today and they may be removed tomorrow.

fyi, I'm doing a leave of absence tracking worksheet. So when someone returns from leave I will remove them from the main worksheet. They can remain on the second one because its only for me to look at.