Excel find, copy & paste in another sheet macro for multiple documents

[Guiri1]

Hey there!
I'm designing some HVAC units with dedicated manufacturer software. After the design is finished the software is automatically generating me a final report of the unit's data, among others, in an excel spreadsheet. The thing is many times I have to make like a shorter summary of the report, on purposes of some projects, other summaries, whatever. And here comes the problem: in generated reports given values (e.g. model name, air flow, weight and so on) everytime are in different cells and I can't make just a simple formulas to copy and paste required information.
Below you can see a screenshot of a part of a report.
report2.jpg

And i would need to obtain a summary alike that:
summary2.jpg

Of course those summaries are much more extended, so it's really inconvenient to do it by hand, this is just to give you the idea.
So I was thinking if it would be possible to write a formula that searches one sheet for a key word (e.g. 'Project'), copy it + value of merged cells on side (1234 - (50)) an finally pastes it in fixed cells in another sheet. It also needs to be applicable to different reports as the values locations varies.


Anybody has any idea how to resolve it? I would appreciate any help. If you need something more like more explanation, excel file, etc. just give me a shout.
Thanks in advance for help!

[dominicb]

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

https://www.mrexcel.com/forum/excel-...documents.html
https://www.excelguru.ca/forums/show...9209#post39209

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.