|What you are asking for can be done, with various levels of automation.|
If you place a version of the code shown below in the ThisWorkbook module of the Master workbook, it will perform the following tasks:
1 - Delete the current Raw Data sheet from the Master workbook
2 - Open the user Raw Data workbook
3 - Copy the Raw Data sheet from the user workbook to the Master workbook as the first worksheet
4 - Close the user workbook
As written, the code will do all of this automatically every time the Master workbook is opened.
If you want more control, you can eliminate the 2 DisplayAlerts lines and you will be warned before the Raw Data sheet in the Master workbook is Deleted. You can choose to have it Deleted or you can keep the original and add a copy of the User version.
If you want even more control, you can run similar code "manually" by not using it as a Workbook_Open event.
Obviously you'll need to change the workbook names, sheet names and paths to match your environment. I've simply provided a generic shell so that you can see what the code could look like.
Private Sub Workbook_Open()
Application.DisplayAlerts = False
'Delete Raw Data sheet In Raw Data Master
'Open user Raw Data workbook
Workbooks.Open Filename:= _
"C:\DerbyDad03\My Documents\Raw Data User.xlsx"
'Copy user Raw Data sheet to Raw Data Master sheet
Workbooks("Raw Data User.xlsx").Sheets("Raw Data").Copy _
Before:=Workbooks("Raw Data Master.xlsm").Sheets(1)
'Close user Raw Data
Workbooks("Raw Data User.xlsx").Close
Application.DisplayAlerts = True
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.