Macro?

check your camera, see if you have a "flower" mode, that is your macro... best thing to do is read the photo topics, using a tripod of some sort- with a timer, has worked best for me so far

I'm still playing around with mine

I use my canon in macro mode with a 10x loupe seems to work fine

I'm sort of a camera buff too... I have a microscope that I have shot coins with and also an old Sony VX2100 that I use for mostly regular shots. I added Macro lens to do coins and they really came out well; but the VX2100 is too bulky for that work. Last year I got a Sony DCR-SX41 with 60X zoom for my wife to do presentations. I decided to try it on my coins... but being an old school photographer, I just don't like the digital automated stuff. It's Either this or it's Either that... no in between.

I use a shooting box (light box). Lights about 90 degrees left and right and a soft light overhead the camera stand. I adjust lighting if there is something I especially want to highlight. I've seen excellent results with the Sony DSC W-290 and would recommend it to anyone.

rastatodd, I gave you the blueprints to a good set up but the most important tool is the camera. I suggest you get a newer one. You really want a clear shot for ebay listings. From what I have seen on ebay, the better the pictures, the more hits your listing will get. Thus potentially more bidders and more money. 8 mega pixels should work well and can be pretty cheap in comparison with other cameras.