find data in another worksheet, multiple actions, maybe overcomplicated. thanks in advance

[grateful_friend]

hello, Thank you for taking the time to read and hopefully help me kill this beast.
I'll get straight to the point

DESIRED RESULT

• Tech enters two search terms
• Sheet finds data in a separate workbook for each term, and returns relevant data to specific cells on multiple sheets in original workbook.
• workbook saves as a combination of 2 specific cells then emails a resulting report (one of the previously mentioned sheets) to the end user that users manager and the tech that entered the search data.

QUESTIONS
can this be done?
is Excel the tool I need or is there a better way in the office suite?

if you need clarification on this request I will gladly answer any questions that will help me reach a solution.
Thank you for reading.

NOTES
2010
I am an excel beginner but I am dedicated to study
I work in a high security job and unapproved or cloud based software is not an option.

[grateful_friend]

I will try to post an example tomorrow as I start to work through it with the recorder, still unsure if excel is the right tool for the job. but sometimes you drive a screw with a hammer... anyway, Thanks for reading.

[FDibbins]

Hi, welcome to the forum

QUESTIONS
can this be done?
is Excel the tool I need....?

Yes, probably, to both questions, depending on your data, and what you want do to. We will be in a better position to say, once we have seen your sample data.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.