Macro to make calculations on each sheet apart from one and transfer data to that last one

Hi All

Thanks for looking at this thread

I need a macro to help me with my accounts.

I have a few simple calculations that I need to make on every single sheet of a workbook apart from the one sheet called Index.

unfortunately, the number of rows does change each time and so does the name of every single sheet apart from the one called Index.

( As a result the code can not rely on the name of any spreadsheet apart from index as these will change each month with my different accounts )

I have attached a sample spreadsheet and the calculations I am trying to get are the highlighted stuff.

Finally I want all the calculated values from each sheet to be transfered to the index sheet as shown in the sample file ( once again highlighted)

Finally the things in green need to be formatted properly, i was having an issue with time showing up as a decimal and vice versa.