Ratcliffe has to obtain them before he can provide them. There's no telling to what degree he actually controls every arm of that hydra.
At this point give a simple order, provide the information within a week or be fired for insubordination, lose all pension and risk further legal consequences for interfering with matters of national security.
No more games, fire the lot of them if necessary, the harm to do domestically likely outweighs any good they do.