Help with this formula =Sheet 1::Table 1::$A$34
I have a Numbers file with 25 sheets that contain information. I like to make a summary sheet with the information located in Table 1 Cell A34 of each sheet. I can do this manually. However; is there a way to type in the formula once and then use the drag feature to populate the rest of the cells? I need a way to increase the sheet number by 1 but keep the Table and Cell addresses static. When I drag down. For example if Cell A1 of summary sheet has =Sheet 1::Table 1::$A$34 I want to be able to drag down and have Cell A2 have =Sheet 2::Table 1::$A$34 Cell A3 have =Sheet 3::Table 1::$A$34....
Thanks for your help