Excel Data classification into categories and General ledger - 5 accounts

I need help classifying the data from one bank account + 4 credit card accounts. The data is for the whole year 2020, the bank account has many more transactions than the credit card accounts. I will provide CSV and PDF bank statements (for the credit card statements I may only provide PDF), and you can work on each one at a time to have a separate report per account, then merge all 5 accounts into the general ledger and category summary. So, once completed the file will have 6 tabs as follows: SUMMARY (this uses the data from the general ledger to show the total of each category) | General Ledger (this has the data from all 5 accounts) | Bank| Card 1| Card 2| Card 3 |Card 4 I'll assist with some information, but I need you to google search the name of the companies paid in order to find the category for most of the entries. The entries are pretty much the same every month for this business (rent, utilities, employee payments, owner compensation, etc). There will be a lot of online charges that are owner compensation, you can google or bing search the name of the merchant to find out what type of merchandise or services were provided for those payment. I can help with the checks on the bank account and giving your general information about the monthly expenses like rent, phone, power, advertisement, donations, employees payment and so forth, but I need you to try to find out with online search the category for miscellaneous charges on these bank accounts.