I imagine that you are leaving the end bracket in place.
Formula:
=(Sheet1!$D$3,Sheet1!$D$6,Sheet1!$D$9,Sheet1!$D$12,Sheet1!$D$15,Sheet1!$D$18,Sheet1!$D$21,Sheet1!$D$24,Sheet1!$D$27,Sheet1!$D$30,Sheet1!$D$33,Sheet1!$D$36,Sheet1!$D$39,Sheet1!$D$42,Sheet1!$D$45,Sheet1!$D$48,Sheet1!$D$51,Sheet1!$D$54,Sheet1!$D$57,Sheet1!$D$60)
Formula:
=(Sheet1!$A$2,Sheet1!$A$5,Sheet1!$A$8,Sheet1!$A$11,Sheet1!$A$14,Sheet1!$A$17,Sheet1!$A$20,Sheet1!$A$23,Sheet1!$A$26,Sheet1!$A$29,Sheet1!$A$32,Sheet1!$A$35,Sheet1!$A$38,Sheet1!$A$41,Sheet1!$A$44,Sheet1!$A$47,Sheet1!$A$50,Sheet1!$A$53,Sheet1!$A$56,Sheet1!$A$59)
Bookmarks