How do I find missing folders and restore links to the catalogue on a Mac?

Has this sorted your issue of missing folders?

Please reply so we can close this thread.

Adobe Lightroom - Find moved or missing files and folders

If your folders are now reorganized by using Finder to something other than the dated folders shown in your screen capture, I don't think there's any easy way to move forward. Reconnecting would have to be done one photo at a time.

Here's a possibility ... create a new catalog, import all the photos again using MOVE, and tell Lightroom to re-create the dated folders that are shown in the screen capture. Then, you are done with the new catalog. Open the old catalog, and you should be able to reconnect each dated folder easily.

What's wrong with those dated folders anyway? You need to use Lightroom tools to organize, not old-fashioned dinosaurs like Folders that were never meant for organizing photographs anyway. Use keywords and other metadata to organize your photos, and use dated folders for storage and leave the photos in their dated folders from now on.