New-Combining certain fields from different tabs in workbook

[Posky]

Hi All,

I have a workbook with 7 different tabs, and would like to combine the last field on every tab onto the last combined tab... this is proving very time consuming--- I'm sure there is way, just do not know how..

I have attached the working file:-

On the combined-Final tab, I would need from tab 1 (Col U) + tab 2(Col R) + tab 3(Col T) + tab 4(Col G) + tab 5(Col T) + tab 6( Col T) + tab 7(Col M). The number of lines on each tab can increase or decrease every month, however the fields will not change, that will be steady...

Thanks you very much for any help..

 

[eibi]

Posky --

I don't understand your desired output.

Perhaps you can copy/paste the values you want into the Final Tab for illustration -- to give a clear vision of the output you want.