Are you talking about putting the sheet music into PDFs and then copying them to Google Drive and accessing them via a tablet?
If so, regarding the size of the tablet: Yeah, my friend does that with his percussion sheet music and he had to get an iPad Pro (12.9") in order to be able to reasonably read it. I don’t know if he uses Google Drive… he may use software that’s specific for this (and it has it’s own storage system).
Regarding sorting: On a file system like Google Drive the only things you can really sort on is “file name” (or folder name) or modified/viewed date… I would organize into sub-folders and then within each subfolder, you just have to name the files smartly to get them to sort the way you want since the file system will sort alphabetically by name. So if you want them sorted by “artist” you would name them with the Artist name at the front or if you wanted them sorted by Song name, you have the Song name at the front. Unfortunately you won’t be able to easy change that after you name them all. Not many options here, those file storage things don’t have any kind of database features behind them.
Now if the main reason you are asking about sorting is because you want to have a way to say build a set list and then have the music in “set list order” at a show or something… and that will change from show to show/etc… maybe look for an app for your tablet that does that… for Example forScore (http://forscore.co)?