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

i didn't understand you. I am so bad with VB, so you should be more precise

Ok, i need real help, not somebody telling me that i have to learn, i know that. I wouldn't be here if i was good at VB, i do other kind of programing , pl sql, oracle, php, css... And when somebody come to me with a problem i either help him, or tell him that i won't, i don't give him advice about learning...
thanks, some reall help guys?

yes, that is why i wrote that i need real help and not advise from a guy who thinks he knows everything just because he learned "very hard " thing - working with excel and Virtual Basic (witch is a bit hard, i admit). Yes i learned them but this forums exist for HELP and not for bragging about knowledge, so you definitely misunderstood the purpose of this website. I know much, and i don't need to learn VB because of one little problem i have...
No time for that, so if somebody knows he will help me, and thanks for your advise but you are no help my friend

i made a mistake typing, because i work, not like u sitting all day getting fat in your chair...
i don't want you to help me so get lost... and yes you exist here to brag... that's sad, you should really help people if you have any knowledge...