Linking information between two sheets

[WW712]

Hello,

I have made a workbook to track our sales team.  I have a main page that has all the leads and the workbook has individual pages for each salesperson and their own leads.  I add comments on each lead.  I would like to import the data from the individuals page into the master page so that whenever I update the individuals page, the information is also updated on the master sheet.

Any suggestions would be greatly appreciated.

[#2]

On the Master Page, insert formulae that point to each of the records on the individual pages.

='Rep1'!A1

Where Rep1 is the name of the individual sheet and cell A1 on that sheet contains the data that you want to appear on the Master Sheet.

[#3]

Thank you.  I have tried doing that but it keeps saying there is an error.  I put  A2:F9  @Doug_Robbins_Word_MVP 

[#4]

In a single cell, use ='sheetname'!A2 where sheetname is the name of the individual sheet, and then copy that formula across 6 columns.