VBA - Printing A Specified Cell-Text to Another Workbook

Hello,

I would like to paste a specified text to my another workbook. In attachment, there are two files: B-Master: My main database, Data: Raw database that the user has. Raw

I would like to print the texts in B1 cells for each tab one by one to my main database. (one on another)

I can print the entire A column for each tab (one on another) to my main database but I would like to print the texts in B1 cell text to Track 5 column one by one until it reaches to Tab 2 Column A then it should get the text in B1 cell then goes like that.

Please take a look at the result tab in Data.xlsx to see what I really want to see.

I would be really really glad if someone help me.

Thanks,

Heffer

Please, I really appreciate any help! Many thanks!