VBA & Excel - Compare, Count and sort

Hello Freelancer, I need a VBA Excel expert. Implementation: ASAP I have a spreadsheet in Excel with the annual billing of an account, see [login to view URL] This spreadsheet is named "total" Task: Write a VBA script to automate data sorting, spreadsheet creation, comparing, summation. 1. See "[login to view URL]". You see a table with values. Most are irrelevant. See column E: For each text with the same content from E8 to the last entry in column E: macro should create a new spreadsheet with the naming of the content inside the column, not longer as 12 signs a. Example: you see Company 1,2,3 + Firma XY = 4 new spreadsheets. Text content in generic, not only company etc. 2. Copy now all columns of B-L which have the identical content of column E into the corresponding spreadsheet, beginning with column A a. For example: You see in "[login to view URL]" three times "company 2" in the total spreadsheet. So the macro in the worksheet has to insert the values in "Company 2" as shown in "[login to view URL]". 3. Then calculate the sum (summe) from column H, see also "[login to view URL]". Leave a row blank for distance. 4. See "[login to view URL]" again In spreadsheet “total” in column A: make a comparison, are all values from column E in “total” spreadsheet right copied in the other spreadsheets (compare with column D in other spreadsheets). Work with colors. Green: ok, red: not ok 5. Macro should create a new spreadsheet, called “Uebersicht”. Show in column A all spreadsheet names, in column B: all total sums from point 3. That’s all Thanks