Scenario - In a summary worksheet there are 50 lines of figures called Plot1
to Plot 50. Each line has a detailed breakdown in a separate worksheet - the
worksheets are called plot 1 to plot 50. For plot 1, I want to refer to
different cells in the "plot 1 worksheet". Then I want to populate the same
formula for all 50 lines of data in the summary sheet without typing in
different references for each line.

How do I do this?