Cwdenver, if you wanted to make the formula dynamic to encompass everything you entered into column A, you would only need to add some named ranges and change the formula slightly.
Add these names...
LastRow: =MAX(MATCH(REPT("z",255),Sheet1!$A:$A),MATCH(9.99999999E+307,Sheet1!$A:$A))
LastA: =INDEX(Sheet1!$A:$A,LastRow,1)
LastB: =INDEX(Sheet1!$A:$B,LastRow,2)
Then your formula would become...
=IF(ROW(B2)-ROW($B$2:LastB)+1>ROWS($A$2:LastA)-COUNTBLANK($A$2:LastA),0,INDIRECT(ADDRESS(SMALL((IF($A$2:LastA<>"",ROW($A$2:LastA),ROW(A2)+ROWS($A$2:LastA))),ROW(B2)-ROW($B$2:LastB)+1),COLUMN($A$2:LastA),4)))
This is also the same array-entered formula, often called CSE formula (Ctrl + Shift + Enter = CSE), ddockstader gave you, so it must be confirmed with CSE instead of just Enter. This is very important: You must CSE this formula in one cell at a time! You cannot multi-enter this formula as you would Ctrl + Enter over a range with a normal formula (if you even do that). If you do not do that, then don't worry about it. Enter the formula in a single cell and copy down as needed.
Btw, in the formula I posted where it says ROW(B2), that is because I inserted a row for headers and anchored the function to the current formula row. Subtle differences. The function will work without them as well..
=IF(ROW()-ROW($B$2:LastB)+1>ROWS($A$2:LastA)-COUNTBLANK($A$2:LastA),0,INDIRECT(ADDRESS(SMALL((IF($A$2:LastA<>"",ROW($A$2:LastA),ROW()+ROWS($A$2:LastA))),ROW()-ROW($B$2:LastB)+1),COLUMN($A$2:LastA),4)))
HTH