Cross Referencing Sheets


We want to create a sheet that cross references another sheet and only pulls in data relevant to the partner with whom we are sharing the sheet. The reason we do not want to use a report for this use case is that you cannot hide the comments from a report and we do not want them to see the row comments.

Please advise which formula(s) we should use to achieve this goal. Thank you!