Search multiple sheets, return entire rows under each sheet name

Hi clever peeps

MANY years ago I was able to write basic VBA, create forms etc, but recent attempts over some largely unproductive hours pretty much tells me I have lost that ability - too long between drinks - so I'm asking for your help.

I have a workbook that has a sheet for each active project (around 10-15 projects at any one time). On each project sheet, there are running lists of tasks with each task assigned to one of our workers.

I want to be able to create a separate list of all tasks assigned to a selected worker (on the 'Your Tasks' sheet). The list is to include the whole row of data for the task.

So, I wish to:
1. Nominate the search value - worker's initials, currently entered via a simple data validation list (e.g. "AB")
2. Check all project sheets for this value, searching in only Column A of each sheet
3. With each successful hit, I'd like two things to occur in the Your Tasks sheet:
a. Insert the name of the sheet (project) in a new row (only once no mater how many hits on that sheet)
b. Beneath the sheet name, return the entire row for each search hit for that project

The ideal result would show the search term (worker's initials) in the data validation cell followed by each project name and the tasks within that project that are assigned to that worker
Please see the attached data sample (simplified and confidentials removed)

Any help welcomed.
THANKS IN ADVANCE

Hi sintek

Thank you for your time and awesomeness!

I notice the use of 'Project *' for the sheet names per my sample data, but this was meant to signify that each project has a different name, so unfortunately it won't work at this stage. I do have VBA code that runs through the sheets and creates a hyperlinked index for me, and I think I might be able to use this with your code.

I'll have a play and try to make it happen, but if you are willing to make adjustments based on this feedback, I'd be very grateful.

Thanks heaps

My apologies sintek
Just to clarify, YES your code WORKS for the sample. Unfortunately not on the working version. I am sorry for sounding ungrateful - the reason I have not supplied a copy of the working file or used actual project names is to avoid sharing confidential information. I am not at liberty to divulge client identities, projects, and/or subcontractor names.
Thanks for hanging in there with me

Hi again sintek
I did substitute the line of code and the code ran. It updated nicely when I changed the search term and rebuilt the list of tasks. However, although the code was running, it was not returning the line with the search term. It returned rows where the cell in Column A was blank. I am now incurring a run-time error on line 27
.Range("A4").Resize(cnt, 3) = Temp
I'm not sure what info you require but you've got it so close! Please let me know what further info would help.
Thanks again

You sound angry. I'm honestly trying not to hinder progress. The truth is, I actually thought I had uploaded a good desensitised sample of the file. I'll try again and this time I will be much more cognisant of what I am deleting and changing.
For the record, I am genuinely very grateful for your help.

Hi sintek
Sample file #2.

Ahhh yes. I have been playing a little to try and understand how your code works; making temporary hard-code changes, running it and learning from the outcome. This is one I hadn't yet changed back to your code.
I'll add a sample expected result as you suggest.

...additionally, 'all tasks' includes ANY row of data on each sheet that has the WHO in Column A. This includes tasks under Ordering (which tells the team what needs to be delivered to site soon), and Current Tasks (which let's us all know what stage the build is at). There will not be a WHO under Notifications. I figured that once you got the code happening for Current Tasks, I'd be able to add other areas of the sheet to the search.

Sample data #2.1

THANK YOU sintek
...on several levels

• for your skill
• for your patience!
• for helping me do this better next time!

Your code is fab!

"Black Duck Black Duck Black Duck..." made me laugh. Clearly I have tested your patience... if I could add another star to your Reputation, I would do so, as I think you deserve it.

MANY THANKS AGAIN