pulling specific data from one sheet to another and updating it weekly

I need this spreadsheet to pick up items from the weekly tabs that have been indicated as a follow-up by putting a 1 in the box (I can't get it to work with an X). Then I need it to transfer over to the Follow-Up tab and keep a running total without the spaces in between each one. I need it to move up so that there are no gaps in between each one. Then I need the spreadsheet to allow for new tabs each week with the follow up tab being a continuous record of any follow ups that we have marked throughout the weeks. The ultimate goal is to have weekly tabs with data that move to the follow up tab to keep track of any such follow up items throughout the year. If you can help I would appreciate it. I will be copying a new weekly tab in each week and populating it with current data so if the formulas could be copied over to a new sheet each week and then with maybe some tweeking they could work on the new tab I could handle that part.

Thanks,
Desiree

I would suggest a real-time macro built into the Follow-ups worksheet. This macro has the added benefit that if you want to use X in column Q you can. As long as you put anything at all, it will work.

Option Explicit

Private Sub Worksheet_Activate()
Dim ws As Worksheet
Dim LR As Long
Application.ScreenUpdating = False

'Clear existing data
    Range("A4:A" & Rows.Count).Clear
    
'Collect current followup data from other sheets
    For Each ws In Worksheets
        If ws.Name <> "Totals" And ws.Name <> Me.Name Then
            With ws.Rows(3)
                .AutoFilter
                .AutoFilter Field:=17, Criteria1:="<>"  'show all rows non-blank in col Q
                LR = ws.Range("Q" & Rows.Count).End(xlUp).Row
                If LR > 3 Then _
                    ws.Range("A4:N" & LR).Copy Range("A" & Rows.Count).End(xlUp).Offset(1)
            End With
            ws.AutoFilterMode = False
        End If
    Next ws

Columns.AutoFit
Application.ScreenUpdating = True
Beep    'sound to remind you the data has just been updated
End Sub

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.