Libre Office calc functions - sheet consolidation - duplicates - comparing the contents of two lists

Hello,

the order is for a Libre Office calc expert, which consists of several functions.

1. There are several hundred sheets with data in 6 columns in the calc file: name + surname, street + number, code + city, phone number, e-mail address, www.

All sheets must be consolidated into one sheet.

2. Duplicates should be removed from this sheet, bearing in mind that duplicates must be searched and removed by e-mail addresses, ie surnames, first names, street names, zip codes and cities are not taken into account and can be multiple.

2. In one column there are names and surnames - in the given order - which should be divided into 2 columns> given names >> surnames

3. From the first names column you should sort the data - whole lines - that belong to female names, the rest will be male names. There are no impersonal lines.

The challenge is that the names are foreign German, French, Italian and English.

If necessary, I can send lists of male and female names from any language.

I am asking for serious offers from professionals who know how to perform these functions.

It is possible that I will have other similar assignments.

best regards

Thomas