Dynamic gathering information from all sheets in workbook




I would like to ask some help on next problem: 

I have a workbook with about 20 sheets. 



Main goals is to gather all 'Remains' into one sheet from all columns. Company, Warehouse, Total for all receivers and Receiver 1, 2, 3, 4 and on and on. 




Issues I've faced: 
1. How to skip all unnecessary columns (income\outcome) as we can just take latest row to get remains. 

2. Get all Receiver names, but the problem is: merged cells, getting #REF or only 1st one and it's shown as Receiver, 0, 0 (in 3 cells)


Attaching a file as example. Thanks. Any help is appreciated. 

0 Replies