Variable reference cell - maybe?

[veghiucatalin]

Hi guys,

I would need some help on extracting some data from an excel file with multiple sheets in one sheet. For the moment, i'm doing it manually but i had enough.
The problem is that in each sheet there will always be added new data (some measurements).

So, the last measurement carried out will start on the row starting with A90 let's say on which Date dd/mm/yy hh:mm:ss is specified (let's say 13/12/2016).
On the next two rows the table header appears( Point Depth Cumulative A Cumulative B and so on). The next time a measurement is performed, for example on the 20th of december, on row starting with A90 the date of 20/12/2016 is specified, and below the table head and the results of the measurement on this date, anew the measurement carried out on 13/12/2016 will start at A146.

Futhermore, for each measuring equipment there's a sheet.

I want to extract, in the same sheet, for all the equipment the measurements at each date.

If you need any example file i can send them at any instance.

Thanks in advance for your time and help.