Hi All,
I am new to Excel Macros. I have powershell knowledge and an understanding, though basic of scripting. Is the following possible and does anyone have suggestions on how to do it.

Scenario...
2 Sheets in a Workbook
Sheet A has a list of items in it that the user will choose from a drop down.
abc
def
GHI

Sheet B has the items listed as well. In the comments on the items in sheet B are tasks that need to be completed for each item. Usually, there are 5 to 6 items such as
ABC Comments would say the following

Task 1
Task 2
Task 3
Task 4


Once a person is done selecting all of the items in the drop down from sheet A, They would then click a button and a new workbook would be created with a new sheet that would copy the comments to cells underneath the chose item.

ABC
Task 1
Task 2
Task 3
Task 4

If other items in sheet A were chosen, the tasks associated with the same item in Sheet B's comments for that item would also be copied next.

It would then look through until all of the cells have been added into a single list with the comments in a new sheet in a new workbook.

Possible?

Scott