My mastersheet feeds 30 other worksheets and I want to be able to link particular cells from my mastersheet to the various worksheets, automatically i.e excel links them and I don’t have to manually link each cell to each sheet.

so that what is in cell A2 of the mastersheet is linked to worksheet 1 and then automatically the information in cell A3 of the mastersheet is linked to worksheet 2 and so on. I don’t want to have to manually link each the cells of the mastersheet to a worksheet.