Power Query Help

Good afternoon!!

Was wondering if this can be helped: Our financial statements software produces Profit/Loss trial balances for all our individual properties (we have 123). Final excel file has 123 tabs (one for each property), tabs are layed out exactly the same. I need to manipulate those Trial balances a bit, like remove zeros and such, nothing big, so when I pull Excel file in PQ, I have 123 queries listed on the side. Question - how can I apply transform steps I perform on one trial balance to all of them at once? I can go back and forth and just copy/paste M code in each query, but I am a spoiled lazy dude. Ideas? Thank you!@

You can create a function.

Apply the transform steps to one query and then paste your M here.

We can convert it to a function so that you can use it on all of your Queries.