Sorting table content

Hei,

One of my clients have a specific request.

He has several clients who make orders on daily basis, he uses google sheets to manage them, marking as order done, not complete etc. Keeps all clients on same sheet, just changes tab daily to new one. He wonders – is there any option to sort out automatically data from sheet and only show client his orders. So that client logs in and only has access to see rows where his name is mentioned.

For example column one is customers name – can it be sorted out on front end to show only his orders by hiding any other clients orders *rows*?