Copy sheet in filepath and paste into another sheet in another workbook

[FullOfQuestions]

Hi I have a workbook with a filepath that has another workbook with a sheet i need to copy and paste. So Workbook “A123” has filepath in cell D42 and I need to open that filepath and copy the specific sheet called “Master Sheet” and paste it into another sheet in workbook A123 called “Allocation 1”. I know this is a lot but I’m completely new to VBA.