copy paste particular lines to other file

[rickmeister]

All,

I would like to copy paste specific lines from an input file to another master document looping through all sheet tabs (the destination master file has the same sheet tab names);

business rule:

if range I16-I100 is not null ("") then copy lines to another sheet but to the sheet with the same worktab

also the copy must be done after the last row, avoiding that items are overwritten when using a different input file.

the copy should be done as from row 16

is this somehow possible using a macro?

Thanks

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.