Simple macro to consolidate text data worksheets into a master one. beginner, no clue

[Mayyalondon]

Hi there,

I need to consolidate 9 worsheets ( with columns A B C rows 1 to 50 ) into one master worksheet.
The data is text only in the three columns.
I have never done macros before and have been searching on google desesperately but cannot make it work!
Could you please kindly help and give me the proper code to make a macro work? I have attached the file.

Many thanks
Mayya