need help! To make multiple sheets from one excel sheet based on criteria

I am not that good with Visual Basic so i don't know how to do this. I have a job that requires selecting a workbook into the sheets based on column criteria.
I found some code that make a multiple sheets from my worksheet based on the column criteria but it makes a sheet for every different value from a column. I need something a little different. When i run that module i need to make multiple sheets from my existing worksheet based on the criteria but with more conditions. For example If i have excel table looking like this:



A B C D
1 no name book phase
2 1 mark 401 55
3 2 ivan 422 152
4 3 john 507 14
5 4 jim 512 1024
6 5 Ros 605 5587
7 6 megan 750 4668

i need separate sheets based on criteria from my column "Book" but i need to have sheets based on a range from that column.

-For example, i need to generate sheet1 that goes from book 401 to book 507
and sheet2 that goes from book 512 to book 605
and sheet3 that goes from 750 to 750

so i need that defined in the code by range like "sheet1 from 401 to 507; sheet2 from 512 to 605"... Or i could name all of them in the code like "sheet1: 407, 507, 508, 509; sheet2: 508,509,510" and do that for all the sheets.
please help me i don't have a clue how to do this but i think it can't be that hard. If somebody could write me a code and i will insert those values individually
and zes, it would be good if i could name my sheets in the code, so when they are made they have custom names, and not "sheet1" "sheet2"...

my excel table looks like this -
Please help, i am not this good at VB and this is the only way to do the job i think. I would be very grateful.

This is a code i found. On this page, it is second code from the top:

http://www.mrexcel.com/forum/excel-q...ed-column.html