Hi Everyone,

I am a self taught excel user. I need your help to solve the following problem.

I have around 50 individual sheets, each with a designated table area (the top left corner cell is same for each worksheet) for cheque details

I want a consolidated "master cheque details" that should get automatically updated sequentially as and when a new entry in any of the worksheet is made.

The bottom row in "master cheque details" has totalling and other figures that should dynamically allow a new entry to remain as the last row entry

Please help