Macro to copy two Sheets matching Source to each workbook in matching Destination Folder

Hello JLGWhiz

Thanks for the code but it is not doing anything
I tested the macro thru F8
It went thru the following lines only before the MsgBox is popping up

Sub copyStuff()
Dim wbsrc As Workbook, wbdst As Workbook, fName As String, sPath As String, dPath As String
sPath = "C:\Source\Master\"
dPath = "C:\Destination\"
fName = Dir(sPath & "*.xls*")
    Do While fName <> ""
......
Not processing any codes in between here
.......
MsgBox "All Files Have Been Processed!", vbInformation, "COMPLETE"

Can you please check?

Thanks once again.

Rashid