To rename multiple tabs of an Excel sheet based on multiple cell values on another sheet

I have an excel sheet with multiple tabs. I need a formula where the each tab gets automatically renamed to the value of cells on another sheet.

For example the 1st Tab should automatically rename to Cell A4 on another excel file called 'Linked Booking log. The second tab to A5, third to A6 and so on.

Pls advise how to go about this..

You will need VBA code to do this.