I do not see a way to use pivot on individual sheet. Pivot will be applicable to all the sheets using that data source.
Multiple Options could be
1. Create another data source with all headers and values in pivot structure
2. Use placeholders so you could manage individual element
3. Create multiple sheets i.e. each row as separate sheet and try to align it in dashboard.
Please find attached workbook for your reference.
Pivot_10.5_v10.5.twbx 75.9 KB