HOW TO JOIN VALUES ON DIFFERENT SHEETS ON 1 MASTER SHEETS see sample

I would like to ask, I have struggle creating Formula on Excel, I have data that automatically inserts to Excel from another software. All I want to do is put them together like in a list on 1 sheet....