I am trying to merge various Calc files having the same structure but different data

The Edit->Merge option does not do anything. I tried the Edit-> Compare sheets as well, but it replaces the data instead of merging. Any help please.

Appreciate it.

Can you post examples of files you want to merge or describe in more detail how you want the merge to operate?