Getting data from multiple values from many sheets in a single screen

I need to get data from various sheets like user sheet, product sheet, category sheet in a single screen.
Whether these needs to related with one another to get values.

Yes, you’ll need to create relations. To create a relation between two sheets, you need common values in each sheet. This could be a user email address, a product code, a product category, whatever.

If relations are new concept, I’d recommend reviewing the related docs.