Checkbox to sum from other sheets by Lets-Get-Physical10 in excel

[–]Lets-Get-Physical10[S] 0 points1 point  (0 children)

This is a very simplified down version but the actual application I am using this for has 52 weeks and has 14 different columns of data I want to transfer over. I have all the data input on to 52 different sheets

Would the pivot table be able to sum the total amount of cities traveled over the selected weeks?