QR System for Food Pantry

Hi everyone!

I’m currently volunteering at a local food pantry. We’ve moved to a QR code check-in system to make things faster for our neighbors, but I’m hitting a wall with the data side and could use some friendly advice.

The Setup:
When someone scans the QR code, their info is added to a "Form Responses" sheet. I already have a Main Data Hub sheet with sections ready for 'New Intake' and 'Returning Guests.'

What I’m trying to solve:
I need a way to have the scan data "populate" automatically into the right spots in the Main Data Hub so I don’t have to copy-paste every week.

1. The Transition: If someone scans and they’ve never been in the system before, they should show up under 'New.' Once they’ve scanned a second time (on a different week), I need them to "transition" or be recognized as a 'Returner.'
2. The Tally: I’m struggling to create an automated tally that counts these scans by week, then rolls them up into a final monthly and yearly total.

The goal is to have a "set it and forget it" dashboard so our team can focus on getting food to families instead of staring at rows of data!

Does anyone have a favorite formula or a simple way to link these together? Thank you so much for any help you can give!