Combine data from Multiple Sheets with Formulas and Images

[Gannas_CI]

Hi I have been able to muddle my way through multiple issues using your threads however have come to one that I cannot overcome.

Using a combine VBA found here, I successfully included data from all of my worksheets.

The issue arises that one column in the copied row has a formula that I want to paste as text and another column is a picture.

Sub Combine()

Dim startRow, startCol, lastRow, lastCol As Long
Dim headers As Range

'Set Master sheet for consolidation
Set mtr = Worksheets("Combined")

'loop through all sheets
For Each Ws In ActiveWorkbook.Worksheets
     'except the master sheet from looping
     If Ws.Name <> "Index" And Ws.Name <> "New Location" And Ws.Name <> "Combined" Then
        Ws.Activate
        Ws.Unprotect
        lastRow = Cells(Rows.Count, 1).End(xlUp).Row
        lastCol = Cells(12, Columns.Count).End(xlToLeft).Column + 6
        'get data from each worksheet and copy it into Combined sheet
        Range(Cells(13, 1), Cells(lastRow, lastCol)).Copy _
        mtr.Range("A" & mtr.Cells(Rows.Count, 1).End(xlUp).Row + 1)
        Ws.Protect
           End If
Next Ws
          
Worksheets("Combined").Activate

End Sub

The formula I want to have the text only result is in merged columns 'V:AB' and the images are in merged column 'AX:BD'

Further to this at the end of each row copied I want the tab name as a reference added to column 'BE'.

I am not sure if this is even possible in the one or if I should try to have a separate lookup match VBA. I tried to write one of those but got a little confused.

Hoping someone can help.