Expanding a formula to include multiple worksheets/tabs

Hi all,

Please see the attachment for more detail on my problem.

I already have an existing formula, but the formula only picks up one tab. I need the formula to gather information from multiple tabs. The information is located in the same cell range on both worksheets/tabs.

Any help would be greatly appreciated.

Many thanks

Raidon