I run an online store. We get daily product feeds from various suppliers but
each supplier has different formats (organization of the data in the
spreadsheet) from eachother and from the format that we need it in.

What I need to do is be able to automatically "map" data from workbook 1
Column A to Workbook 2 Column F, etc., etc.,

Thanks,
Kevin