I'm trying to set up a loop to pull data from multiple cells in multiple worksheets

Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee

Add this line to the end of each Macro I gave, it will change the date in cell N2 which shows when the table was last updated.

A_LBVN.[n2] = Date

Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee

Is the table on your actual file named something other than "Table1"?

Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee

Try changing that macro to:

Sub btnUpdate_Click()
    Dim ws As Worksheet, lRow As Long
     
    Application.ScreenUpdating = 0
    With A_LBVN
        For Each ws In Sheets
            If Len(ws.Name) < 5 Then
                lRow = IIf(lRow = 0, 7, lRow + 1)
                .Cells(lRow, 2).Resize(, 13) = Array _
                (ws.[b6], ws.[b30], ws.[b18], ws.[b9], ws.[b12], ws.[b15], ws.[b21], _
                 ws.[b33], ws.[b27], ws.[j30], ws.[f24], ws.[h24], ws.[d18])
            End If
        Next
        With .ListObjects(1).Range
            .Sort .Columns(1), , , , , , , 1
        End With
        .[n2] = Date
    End With
    MsgBox "Database successfully updated", , "Database Update"
    
End Sub

That should work no matter how the Table is named.

Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee

You're welcome.

Have you had a look at the file attached to Trebor's post (Post #19) to see how use of formulas works?

Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee

Quote

I have not. But I will. I am anxious to learn more about VBA now.

Just bare in mind that formulas are always more efficient than code.

Well done to KjBox for the nifty solution provided

Robert