Excel as a database of Forms

NewbieNik I've just re-read your post and hadn't realised before that you want a user to enter an email address and all the items assigned to them would be displayed. That is certainly not possible with Forms as it cannot lookup information. The only way to achieve that sort of user experience is to build an app in Power Apps. If your users are all internal it would automatically know who was signed in to Office 365 and display "their" information automatically and they wouldn't see anyone else's. A bit like the app I built for my company below

Then with Power Automate you could send the user an email at regular intervals asking them, via a button, to confirm they still have the equipment. That would trigger a flow which would save their response into a SharePoint list.

If I get some time over the next couple of days I'll build a quick demo.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)