I currently have a spreadsheet that I can use to search a folder using
Application.FileDialog(msoFileDialogFolderPicker) to give me a list of files,
then use formulas to find the files I want.

What I want now (for something else) is to search a Folder (preset based on
date) and return all the files as variables rather than as pasting them into
cells. There shouldn't be more than say 25 files in the folder, and no
subfolders. This will be used in a userform that will have 25 buttons that
allow the user to open any of the files easily. So I'll want the full path of
each file as a variable to assign to a command button (or have the macro
assign the filename when the file is found rather than to a tied in variable?)

I've looked at a couple of things and they seem vastly complex and I can't
seem to modify them to just give me the results as a variable rather than in
a cell.