First, you should read the guides in the macro section:
Macros and Close-ups
Next, consider joining a macro outing. For example:
http://www.clubsnap.com/forums/gath...-macro-shoot-17th-jun-2012-a.html#post7959919
But without some basic skill and talent, you cannot get a "great pic" by relying on gear alone. You need to learn how to use your gear first. Then use your gear to express your creativity. Just buying a 60D and raynox 250 will not give you great pics. It requires patience, practice, luck and more practice.