Excel paste special automation

Job ID: 35428883

Budget: ₹600 – ₹1,500 INR

I have date based formula to fetch daily balances. Once the day is done, i wish that values to remain the same and change the next day when the date changes. To do this i am using paste special but i have 20 worksheets and it takes a lot of time and is also boring.

Need help to automate it.