I have a different worksheet than the one i am going to describe. I'm just
going to make this one an example.

i would like to have my tab have all the information. But on my second (or
more) tab i want it to display specific information. Say i wanted it like a
calendar function

The bottom tabs would be Day(all info), 12 am, 1 am, 2 am etc.
In the Day tab i would have as headers:
Name, Date, Remarks, Time.

Then under those headers you would have the needed information. Say it
would be.

Beetlejuice, Monday, Call his name 3 times, 2 am.

So i was wondering if there was a way to make it so under the 2 am section
that anything in your Day list that is 2 am would auto show up in 2 am only
by entering in information into the Day tab area. And it would automatcially
fall under the headers of Name, Date, Remarks, Time in the 2 am tab.

If there is any way i would so love to know how. If not please let me know
so i can stop getting my hopes up. or if needing more info let me know. Thanks