Pull a cell data of multiplie sheets using colour code to one summary

[jibin92]

Hello, can you please advice, i have 20 sheets in one workbook, i want to take a cell data of all these sheets to one summary, eg: bank closing balance. so every week, when i update these sheets, the summary of balance also need to update automatic using formula of color of cell or etc. please help