To make a simple basic unit like you had mentioned in a PM try the following:
Take a unit with a similar palette to the thing you want to make.
Since you don't want animation, open the default.flc with flicster or civ3flcedit (both are free and on here).
Both have options to save the FLC as a storyboard. Flicster saves the storyboard with a paintshop palette, in case you want tweak the colors. Open the default.pcx with your paint program. Paste in the images into the storyboard. Load the storyboard with Flicster and save it as a FLC.