Sheffield Archives should have a copy of any records for Penistone Workhouse. But my vague understanding is that not many of the records for Penistone actually survive.
If you provide details of your ancestor then someone might be able to help you further with your search.