I've been elected popcorn kernel for our boyscout troop and am working on setting up a spreadsheet to help keep track of everything.

I plan on having a data sheet that contains lists of the scouts, the products, and the type of sales events; a template sheet used for creating individual scout reports, and several journal sheets for itemizing the sales of order events.

I would like to be able to run a macro that would start with the template, and for each scout copy the template add the events for that scout. The macro would then do the same for the next journal (I think I will have one for sales and one for orders but I may actually have 3 different journals - each in separate sheets) adding those events after the earlier journal entries. (All the journals will have a name column which the macro will use to sort the entries)

Does this sound reasonable?
Any ideas on how to proceed?

Thanks in advance.