Summary sheet from notes in worksheets

Hello,
Im NEW!!!! :-D

I thought i was pretty good at excel..... haha

I'm helping out a friend and have a great idea but cant seem to put it into practice.

What I'm trying to do is create a client workbook for him. Within the workbook there is a summary worksheet up first, then subsequent worksheets for each client visit.
I'd like to pull the most recent notes from the most recently used worksheet onto the summary worksheet and cant seem to work out how to do it pulling the data from multiple worksheets.

I may have over complicated my idea and might be missing something but ideally if sheet 4 was the most recently filled in id like the notes from that to pull through rather than him having to look through the tabs for the last one used.

Make sense to anyone?

I've been doing a bit more digging around and the & formula should work, but isnt pulling data across from more than one worksheet. Is this normal?
D