We often get the question about why a macro shot isn't as perfect as some photographers produce. Well, the answer may not be what you want to hear. Professionals, or even great amateurs, who want to get a perfectly focused and sharp macro shot use a post production technique called Focus Stacking. You stack multiple shots that are focused on different areas on top of one another to get that perfect shot.
B&H has a great article on how to get this done. Good luck!