Invalid nested formula syntax

maybe: 'tab- 1'!A1.....

the best way is attach example excel file

edit:
all used names of sheets should exist in your workbook else formula lookin' for another workbook or non-existing target with used name