ENH: support reading from several files for read_* functions
#### Is your feature request related to a problem?

In general, the implementation of this idea should contribute to simplification of reading functions use and reduce the use of boilerplate code.
On the other hand, this shouldn't make it much more difficult to maintain that functions in Pandas.

Current reading approach (from Pandas docs):

```python
  import glob
  files = glob.glob('file_*.csv')
  result = pd.concat([pd.read_csv(f) for f in files], ignore_index=True)
```

#### Describe the solution you'd like

We can make reading several files as "out-of-the-box" feature of Pandas (with using wildcard):

```python
  result = pd.read_csv('file_*csv')
```


#### API breaking implications

In one of the two proposed solutions: `filepath_or_buffer` also can be of `list[str]` type.
Changes do not break backward compatibility.

#### Describe alternatives you've considered

Another possible option (using list of files in `read_*` call):

```python
  import glob
  result = pd.read_csv(glob.glob('file_*csv'))
```


