You will need to set up filter Dashboard Actions so that when you select a value on the main sheet, the three sub-sheets are filtered
Go to Dashboard > Actions... > Add Action > Filter... to create a new filter.
See attached example using superstore data where the bar graph is the "main" sheet and the two below are the sub-sheets that get shown and filtered when a selection is made.
Source Sheet: check only the box for the sheet that is your main sheet
Target Sheets: check only the boxes for the sheets that are your sub-sheets
Run action on: use Select to have the filter trigger on click. Menu will mean the user must click a value, then click the link in the popup. Not really what you want here.
Clearing the selection will: use Exclude All Values to hide all values unless a value is selected on the main sheet.
Target Filters: select All Fields then click OK.
If you want to show the last order notes you will need to set up a second sheet that shows only the latest order notes and set up filters for hide/show of the sheet depending on if anything is selected. There are a lot of examples on hide/show sheets in this forum. I would suggest you start with showing nothing because it will draw attention to the notes when a selection is made and that sheet is populated. Especially if you are showing a list of orders, to show the latest order notes could be confusing.
I also included a second dashboard action to show how you can filter from the sub-sheet to the other sub-sheet if interested.
filtering between sheets.twb 264.1 KB