Copy and paste data from different sheet.

Hello,

I have a small problem. I have made dependent lists in excel to capture the data. However, to sum up the data, I need to pick up the entire list of product names from the sheet names "Master" and copy paste the same dynamically into sheet called "View".

The user will select the "Category" (A total of Six categories exist) and depends on the category he select, I need to list all the products defined under that category in the column adjacent to the column where user is selecting the category.

How do we get this done using VBA code?