Hi,



I am looking to use this formula =SUMIF('1-April '!$A$2:$A$600,$A4,INDEX('1-April '!$E$2:$Q$2,MATCH(E$2,'1-April '!$E$2:$Q$2,0))) to look up values on all tabs in the work book called 1-April, 2-May, 3-June etc. I know I could do + and change the tab name but there must be an easier way? I might not even be using the best formula in the first place?



Thanks

Sorry Hi I am new and don't know much. Learning as I go