Hi, whether the below is possible I do not know, but if it is I would appreciate some help.

In "Workbook 1" I have 10 Worksheets, all the same, all containing a Command Button, to which I would like to assign a Macro. Upon being pressed, I need the Macro to do the following:

Open "Workbook 2" (which will be a set template) and populate Workbook 2 with data contained in various cells in "Workbook 1", but ONLY from the Worksheet in which the Command Button was pressed.

So, say for example in WorkBook 1:

A1 = "Name"
B1 = "Date" B2 = "Time"

This is the same in all 10 Worksheets.

Then, I press the Command Button in Sheet 3 for example, and Workbook 2 opens and populates D1 with "Workbook 1, Worksheet 3 "A1", D2 with "Workbook 1, Worksheet 3 "B1", D3 "Workbook 1, Worksheet 3 "B2".

The important thing is that the populated data should only be taken from the Worksheet in Workbook1 in which the Command Button was pressed.

I would then manually save a version of Workbook 2 and close it down etc.

Does this make sense and can it be done?

Thanks,
PAS