Sub ProcessFiles() Dim folderPath As String Dim fileName As String Dim wb As Workbook Dim ws As Worksheet Dim outputWb As Workbook Dim outputWs As Worksheet Dim rowCount As Integer Dim regexPattern As String Dim matchFileName As Boolean Di…