i have 50 over worksheets and they are all the same format.

now , i want to consolidate all the datas( from the 50 sheets) into one worksheet.

now, i am using =sheet1!A1+sheet2!A1......sheet50!A1 to calculate the output

is there a better way of doing this? something like =sum(sheet1!:sheet50!)_all

the_cells_in_A1 without having to point to the exact cell of each worksheet?