Macro - Sorting Data

I am a mechanical engineer by trade and am working in Excel to manipulate data. I have written macros in the past, but have come to a stumbling block. For simplicity say I have a column of timing information such as:

Time Sequence
1
9
15
23

Then I have another column of sequential time:

Time actual
0
1
2
3
4
5
etc.

I want to be able to take the first two values of the first column, search the second solumn for any values between those numbers, then create a new spreadsheet and copy those rows to a new spreadsheet, then loop back to search for the next two sets of numbers. So I want to search my actual time for values between 1 and 9 and put them all in a new sheet, then search for values between 9 and 15 and put those in another new sheet, etc.