Excel Reformatting Tool

Hi,
I am looking for an off the shelf product that can import an excel file of a certain format and reformat it to conform to some saved output file settings. eg. an excel file with 3 columns named A1, A2 and A3 to be converted to an excel file with 2 columns called B1 and B2 where A1 maps to B2 and A3 maps to B2.
I would like to be able to save numerous conversion settings in order to re-use daily and also the product would need to be able to support excel 2002/2003. Any ideas?