Working with Worksheets in excel

This might be very simple to some ...but will change my world if I can figure this out.

I have a master worksheet (dashboard) that is linked to other worksheets (worksheet 1, worksheet 2 etc.) within the same workbook. If I add another sheet I have to go through the entire sheet and link it to my master worksheet (dashboard).

My question is how can I copy all of the information from Worksheet 1 to worksheet 2 and still have it coect to master worksheet (dashboard)?

Example:

Worksheet 1 has sales information for certain product. Key components are coected to the dashboard (product name, quantity, margin, exchange rate etc.). All of this information is linked to row 1 in master workbook. Worksheet 2 is linked to row 2 etc.

The master workbook (dashboard) has totals and other calculations. If I want to add another worksheet #3 - which would go to row 3 ...how can I do this without having to manually link all of the cells?

I hope someone can help me with this!

Thank you!

From a novice excel person :)