A Semi automated way to note the IP addresses of things viewing us

[DocAElstein]

Splitting SummaryRequestsIPs.xlsm and tidying up a bit
I want to spilt/ consolidate/ tidy up or similar to get a more full All columns – maybe a few across the whole time so far and maybe try to follow to some extent the patchy log notes so as to maybe get typical behaviours over a few days, if possible.
I mean I want columns not too dissimilar to what I did so far for the IPs and Requests over certain time periods
https://i.postimg.cc/2592Hkj1/All-IPs.jpg
https://i.postimg.cc/TwyQFzhD/All-Requests.jpg

SummaryRequestsIPsDailys.xlsm
For the time being I may leave the Unknown locations worksheet , https://i.postimg.cc/Y948Z5jL/Unkown...-Worksheet.jpg , without an All worksheet perhaps left initially in a simple summary file,
SummaryRequestsIPsDailys.xlsm
This file will that used to pull into it the daily files, (daily files being the files like IPAddressesWatchingExcelFox_Refresh 7min 1674 84 samstag 18 oct 840 er.xls )
(The file SummaryRequestsIPsDailys.xlsm is split out from SummaryRequestsIPsAlls.xlsm ) I might copy all or bits of the Unknown locations worksheet here and there to help in any time periods analysis and may even do a limit All on it from time to time
So SummaryRequestsIPsDailys.xlsm will reduce to 3 worksheets

( I will tidy up just slightly the coding used to get the clipboard copy that I (will likely still ) manually copy to the SummaryRequestsIPsAlls.xlsm , and I will add/move the two unkownlocations coding as the third ( forth ) to be done from the daily files)

SummaryRequestsIPsAlls(Merge).xlsm
I will now split further to get a file, SummaryRequestsIPsAlls(Merge).xlsm which I will start by copying some of the All columns from the previous SummaryRequestsIPsAlls.xlsm

SummaryRequestsIPsAlls.xlsm at its current form will be renamed at this point to SummaryRequestsIPsEarlyRickEtc.xlsm , to use if I get back to looking at the Crazy Alligator Log Days. My thinking that as time has gone on things may have moved on so there is more than enough data to use to reanalyze that bad early crazy time