Google Sheets Macro for Concatenation

I'm seeking a Google Sheets expert to create a macro with a "generate button." This macro will concatenate multiple rows into one line, based on a selected range, and place the result in a single field on a separate tab.

Requirements:
- Concatenate rows based on a user-selected range.
- Use a specified delimiter for merging.

Ideal Skills:
- Proficient in Google Sheets and Apps Script.
- Experience with creating and implementing macros.
- Attention to detail and ability to follow specific instructions.