How do i allow a user to see data on a report, without giving them access to the Master Data sheet


I have a form that feeds data into a master sheet/grid. I have am automation that separates the data by teams. I have a specific report that that has the information pulled in from the main page and i tried to give somebody access to just that sheet but they cant view any of the data. The only way they saw any of the data is by me giving them access to the main/master sheet (which i don't want). How do i allow somebody to view a report without giving access to the master sheet. Any help is appreciated.