Need Excel to automatically select correct columns to sum their values by currency

I think you should use pivot table.

But without your data, i can't show you.

Not sure if the pivot table would be a good solution for my problem. On tab 2 I will collect the totals from many other tabs (like Labor costs (total for salaries in one weekly number), Loans and interest on loans in one weekly total etc.