IP Subnet Comapre and write

Hi Members,

I am totally new to this forum and also have verly less knowledge when it comes to excel. Hence expecting kind assistance from users on resolving one of the repeated task I confron every week. The scenario is as below:

I have a Workbook(IP Allocation) with sheets named by location. Each location has subnet information belonging to that location alone in it.

I have another workbook(Hosts) with a sheet which IP address with other parameter for that IP address.

Task: Need to compare IP from Hosts workbook with the IP Allocation workbook and write that to a new workbook (probabily named as Host Analysis). It should be written in such a way that each Ip from Hosts is sorted to its respective location sheet.

If a macro can be created for the same, it would be much better.

I am also attaching sample for all three workbooks for better understanding.

Thanks in advance for any assistance in this regard.Host Analysis.xlsxIP Allocations.xlsxHosts.xlsx