mail merge from excel to excel

[rehab]

Normally I use word but in this case I had to create an excel "form" and I want to reference a separate workbooks data. Once processed, my goal is to generate either separate sheets or individual workbooks based on the source files ROWs.

I have tried the VBA scripts referenced through searching for a solution but none of them are generating multiple sheets or books. Is there a way to just reference Columns and sequentially run down the spreadsheet like in a Word mail merge?

 

[modi123]

I am not tracking what you are asking. Though I could sort of see this being done in C# or VB.NET.

You can reference other sheet names in a work book by using;
=sheet_name!cell_address
.. if the sheet name has a space or something odd in it.. then surround by a tick mark.