Need help generating an autonumber

I got a large Worksheet for my Police Departments Ticket Book Logs.

I have one sheet that lists all tickets ever issued
I then have a second sheet that list all possible tickets

I now am creating a log when I issue new ticket books.

On this table I got the following fields

Ticket Book #
Date Issued
Ticket From #
Ticket End #
Officer Issued
Supervisor who issued book

I am fine with hand entering all the data except the Ticket Book # info.

what I need here is the following. I need the Ticket Book # to be one (1) greater than the max number listed in the All Tickets Sheet?

Is there a way to do this?

I want it to be like an autonumber.

Thanks

Matt

Kinda I need it to search (Table2[Ticket Book#]) and to give the next ticket book the next number

For example I think the last ticket book in (Table2[Ticket Book#]) is 1663. So I want the next ticket book to be 1664

ok I got an older copy that should show you.

I am trying to create sheet at the end where I can enter in new books and it takes the next highest book number from All Tickets Sheet