I have tried the VBA Code to search multiple worksheets and return answer in the Dashboard.I hit a glitch in setting the dataArray parameters.
The titles start of Row 7 in all worksheets, including the "Dashboard" worksheet". The number of columns is 10. Searching of data will have to start with Row 8 as shown in attached screenshot
Many thanks for your assistance in advance