Linking data from another workbook

I have 2 excel Workbooks:

1) Report Workbook
2) Data Source Workbook

Workbook #2 will have rows added dynamically from our users. I want workbook #1 to add a row automatically with the new information from those rows.

Is it possible for workbook 1 to automatically grow along with #2? If so, can someone give me an example or tell me how I need to set it up?


Thanks!

Just write a formula to add the lines.