Which is the best camera for close up shots (macro) .?

I have been asked to produce a leaflet that require me to do macro shots. I would prefer a camera that is not too expensive.