Collate multiple workbooks with filenames

Hi All,
I think my question is very simple however I am suffering to get it done.

Problem Statements:-

I need collate multiple workbooks data into one where worksheet name is same in all workbooks. I just need use used range i.e. no specific range. While collating data I need file name in each row in last column. I have attached sample raw data workbooks & Master one.

Exception: - Every time macro should not add new workbook while collating data. Macro should simple delete (Ctrl+A+Delete) data from master workbook(All Data).

Solution Statements: - You are my solution. I hope I will get help here.