How to increment data using two sheets in excel

[Keo1037]

I have two sheets: sheet 1 contains a list of orders in ascending order. Sheet 2 is supposed to extract the last order number in sheet 1 and increment it by one.
This is what I have come up with:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=INDEX($A:$B, 29,1)</code>but essentially this is what I need it to do:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=INDEX($A:$B,29++,1)</code>

 

[Special-K99]

Try

=INDEX($A:$B,28+ROWS($1:1),1)
copying down the column