This code works for me if I am importing two sheets:

```
={IMPORTRANGE("Sheet1Key","SheetName!A2:A500");IMPORTRANGE("Sheet2Key","SheetName!A2:A500")}

```

However, I have multiple sheets, all in the same folder, all with the data in the first sheet and all with the data in the same cells. 

Is it possible to somehow either import from a folder or somehow add the IDs or names of all files within that folder automatically?