I need help in being able to do the following:

- In Worksheet A I have raw data.
- In Worksheet B I have a template with formulas.
- The data on Worksheet A change on a weekly basis.

I need to find a way to select the raw data from Worksheet A and insert it in Workbook B. The formulas of Workbook B are at the right of where raw data should be entered and also down at the end of the raw data. Clearly my problem is that I have totals and the number of rows of raw data change.