How to transfer data worksheet to worksheet

I have a schedule I designed for work and need to show the last 2 hour of one shift on a new work sheet for the next shift. The data will change weekly but I need it to show up so areas are not double covered or missed. How can i make this happen?