Formating excel multiple paragraphs and colums using one source of data
 

Scenario:
Sheet#1:
column #1 product names separated by category names.
column#2 prices corresponding to products.

Final sheet is basically all product pricing.

To print this out i need to create lay out on sheet # 2
This sheet would have three vertical frames.
this frames would have two columns(one for product names one for
pricis)
Sheet #1 would project the content to sheet #2 in such way that if
sheet #1 content changes all the content would get formated in number
#2 sheet accordingly .(This content will have multiple pages within a
sheet.

How can I achieve that?.