Using data from other Worksheet with multi Tabs

[Turbo68]

What i need is to get a formula that will copy some data from another sheet and tab but I want to be able to use cell data for the TAB name.


[FONT=&quot]=SUM[/FONT][FONT=&quot][Sales.xlsx]Jan!B2:B5)

[/FONT]I want to use cell data for the JAN! Lets say that month data is in A10..A22 ( all the months) Then all i need to do is copy this down to get it to go to the FEB tab and MAR tab and so on.

[FONT=&quot]Thanks in Advance!

[/FONT]

 

[shg]

=SUM(INDIRECT("[Sales.xlsx]" & A10 & "!B2:B5"))

 

[Turbo68]

Thank you!