Oh that makes sense now. I am using the consolidatedsheetsfromworkbooks and I am getting a debug error on

fName = Dir(fPath & "*.xlsx") 'start looping through files one at a time

My master workbook is called "Master". and i have three tabs that are labeled the same as the ones in the workbooks I am wanting to merge. Any suggestions?