Thank you so much!! I guess I'm not as comfortable as I thought with
macro's. I edited your macro to fit my sheets names & cells correctly
- not working.... I feel terrible you're taking the time to help me &
I didn't give you what you needed from the start.

Better example:
I have a sheet 'August Tickets Log' that I enter all tickets in for
that month.
I have a second sheet 'Matthew's - August' that pulls over all Matthews
tickets.
I have another sheet "Marsh - August' that pulls over all Marsh
tickets, and so forth.
And then, I have a sheet 'Matthew's 08-2006-Invoice' that I use to pull
that weeks' tickets for Matthew's from the 'Matthew's - August' sheet.
And the same for all the other trucking entities.

My goal was to have a sheet in the front with button commands: 'Enter
tickets' to take me to the main sheet; 'Matthew's Invoice' pulling that
weeks tickets for Matthew's... etc. [week 1, week 2, etc.]

I'm probably making this more complicated than it needs to be, but I
want to be prepared as I take on more leases. I've looked up functions
and researched books - I can't seem to make anything work with the
dates.

I don't blame you if you don't reply again, but if you do - thank
you...

Thanks,
Rondia