Hello guys this is my first post.

I am having a issues with tracking information from multiple
worksheets in the same document

I have listed the names of each worksheets from O2:O127

I need to find a code that says if M40 is 1 then add up B12, B22,
B32, B42, L13, L33, L43 If not 1 then ignore.

Please help me!