The best way to handle sharing files with large and dynamic groups on Google Drive is by using Google Groups, but it's also possible to do the way you are thinking by using Google Apps Script or the Google Drive API and the Google Sheets API
To use a group from Google Groups to handle sharing files, share the files with the group by adding its email address....
If the file was removed from a shared folder:
If you own the file and you deleted it, the file will be in your Trash. You can search your Trash to find it. Other people will still be able to find the file using the URL for that file, if they saved the URL (which always remains the same). Or, they could see in the Activity pane on the right-hand side of the ...
That occurs because you aren't the file owner. Only the owner is able to delete the file.
To see the files "hidden" by remove, go to https://drive.google.com/drive/shared-with-me.
To see the files that actually use your storage quota go to https://drive.google.com/drive/quota