How can I apply formatting uniformly across multiple sheets/tables?

Alright, I will try to make this brief and concise and I appreciate any help anyone is willing to give. Here's my situation:

I have a bunch of PDF files that contain data I need to manipulate (some auditing reports). To achieve this, I exported the PDF files as .xls files via Adobe Acrobat Pro DC. Now, this works pretty well - better than I thought it would honestly. However, the issue is that I'd like to apply additional formatting to these (newly exported) worksheets. Ideally, as the title says, I'd like the formatting to be uniform for all worksheets and, ideally, I'd like to automate this process.

My first thought was to simply record a macro, where I manually format one of the sheets and then simply apply that same Macros to all the relevant worksheets. The issue here is that the number of  data entries (that is, rows/columns), may differ between worksheets. So if sheet 1 has 20 rows and sheet 2 has 40 rows, a significant amount of data will not be included in the formatting, since I recorded the Macro on sheet 1.

The real question: How can bulk format several Excel worksheets/tables/workbooks uniformly, given that the number of data entries per [worksheet] may vary? Again, any help would be greatly appreciated.

Thank you